Topic: SQL Query
New with Topic: SQL Query
pinaldave posted a blog entry
SQL SERVER – Differences in Vulnerability between Oracle and SQL Server
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more...
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more...
pinaldave posted a blog entry
SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation
To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and...
To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and...
2 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Server
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Serverpinaldave posted a blog entry
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
I would like to start this post with an interesting question:Where in MS SQL Server is “100” equals to “0”? And I am...
I would like to start this post with an interesting question:Where in MS SQL Server is “100” equals to “0”? And I am...
3 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL BOL
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL BOLpinaldave posted a blog entry
SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth
Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp...
Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp...
4 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL...pinaldave posted a blog entry
SQLAuthority News – An Year of Personal Events – A Life Outside SQL
Today I will keep the words very short and will convey story in three simple photographs. This post answers the question...
Today I will keep the words very short and will convey story in three simple photographs. This post answers the question...
5 days ago
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authority
pinaldave posted a blog entry
SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008
When a database table grows in size to the hundreds of gigabytes or more, it can become more difficult to load new data, remove...
When a database table grows in size to the hundreds of gigabytes or more, it can become more difficult to load new data, remove...
6 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQLAuthority News – Featured on Channel 9
This blog was featured on Channel 9 MSDN over here : TWC9: Scott Hanselman, Jon Galloway, Bing, parallel unit tests, more. I...
This blog was featured on Channel 9 MSDN over here : TWC9: Scott Hanselman, Jon Galloway, Bing, parallel unit tests, more. I...
pinaldave posted a blog entry
SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication
Replication has been my favorite subject when it comes to resolving errors. I have found that many DBAs are stuck with the...
Replication has been my favorite subject when it comes to resolving errors. I have found that many DBAs are stuck with the...
8 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Error...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Error...pinaldave posted a blog entry
SQL SERVER – Future of Business Intelligence
Business Intelligence (BI) is slated to play bigger roles in all kinds of businesses in the coming years. This is not...
Business Intelligence (BI) is slated to play bigger roles in all kinds of businesses in the coming years. This is not...
pinaldave posted a blog entry
SQL SERVER – Business Intelligence – Aligning Business Metrics
Today, executive management and managers need the latest information to drive intelligent decisions for business success. More...
Today, executive management and managers need the latest information to drive intelligent decisions for business success. More...
10 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Business..., Data..., Pinal Dave, SQL
Journey to SQL Authority with Pinal Dave
| Topics: Business..., Data..., Pinal Dave, SQLpinaldave posted a blog entry
SQL SERVER – Fix : Error : Invalid object name ’sys.configurations’. (Microsoft SQL Server, Error: 208)
As you all know that SQL Azure CTP has been released; here, I have included a step-by-step guide for how to configure the CTP:...
As you all know that SQL Azure CTP has been released; here, I have included a step-by-step guide for how to configure the CTP:...
11 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Error...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Error...pinaldave posted a blog entry
SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman
The performance and stability of any application solution—whether line of business, transactional, or business intelligence...
The performance and stability of any application solution—whether line of business, transactional, or business intelligence...
12 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Business..., Data..., Pinal Dave, SQL
Journey to SQL Authority with Pinal Dave
| Topics: Business..., Data..., Pinal Dave, SQLpinaldave posted a blog entry
SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008
What are the considerations when creating a consolidation plan for my environment?What are the key differentiators among the...
What are the considerations when creating a consolidation plan for my environment?What are the key differentiators among the...
13 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Database, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Database, Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore
I recently had opportunity to attend TechDays 2009 Infosys. This event was the largest technology conference by Microsoft in...
I recently had opportunity to attend TechDays 2009 Infosys. This event was the largest technology conference by Microsoft in...
pinaldave posted a blog entry
SQL SERVER – 2008 Star Join Query Optimization
Business Intelligence (BI) plays a significant role in businesses nowadays. Moreover, the databases that deal with the queries...
Business Intelligence (BI) plays a significant role in businesses nowadays. Moreover, the databases that deal with the queries...
15 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Business..., Data..., Pinal Dave
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Business..., Data..., Pinal Davepinaldave posted a blog entry
SQLAuthority News – Airline Review – Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines, Spicejet
First of all, this is a totally different article that I have ever written on this site. As the regular readers of my blog are...
First of all, this is a totally different article that I have ever written on this site. As the regular readers of my blog are...
16 days ago
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER – Validate an XML document in TSQL using XSD by Jacob Sebastian
Following article is sent by SQL Server MVP Jacob Sebastian on request to provide solution for validating XML document.XML...
Following article is sent by SQL Server MVP Jacob Sebastian on request to provide solution for validating XML document.XML...
17 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQLAuthority News – A Daily Doze of Technology – Alvin Ashcraft’s Morning Dew
A common question that I receive is regarding how I keep myself updated with latest information about technology and what is...
A common question that I receive is regarding how I keep myself updated with latest information about technology and what is...
18 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Server
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Serverpinaldave posted a blog entry
SQL SERVER – Size of Index Table for Each Index – Solution
Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution....
Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution....
19 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, Readers..., Readers..., SQL
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, Readers..., Readers..., SQLpinaldave posted a blog entry
SQLAuthority News – SQL Server R2 Resources Downloads, Documentations
Microsoft SQL Server 2008 R2 November Community Technology PreviewBuilding on SQL Server 2008, R2 provides an even more...
Microsoft SQL Server 2008 R2 November Community Technology PreviewBuilding on SQL Server 2008, R2 provides an even more...
pinaldave posted a blog entry
SQLAuthority News – Subscribe to Blog – Search a Blog
Quite often I get request if I send blog post in newsletter or through email. Here are few important links.You can for sure...
Quite often I get request if I send blog post in newsletter or through email. Here are few important links.You can for sure...
22 days ago
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white...
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white...
23 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Business..., SQL, SQL Authority, SQL...
Journey to SQL Authority with Pinal Dave
| Topics: Business..., SQL, SQL Authority, SQL...pinaldave posted a blog entry
SQL SERVER – Comma Separated Values (CSV) from Table Column
I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma...
I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma...
24 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY
Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while...
Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while...
25 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
tixrus posted a tweet
rt @burntsugar @imasoom BOOM-TISH!! A SQL query goes into a bar, walks up to two tables and asks, "Can I join you?" #geekjoke
pinaldave posted a blog entry
SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index
In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature...
In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature...
26 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...pinaldave posted a blog entry
SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas
I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. Bookmark lookup or key...
I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. Bookmark lookup or key...
27 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Index
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Indexpinaldave posted a blog entry
SQLAuthority News – SQL Server 2008 for Oracle DBA
This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience...
This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience...
pinaldave posted a blog entry
SQLAuthority News – Book Review – Expert SQL Server 2008 Encryption by Michael Coles
Expert SQL Server 2008 Encryption (Paperback)Michael Coles (Author), Rodney Landrum (Author)Link to Amazon“What is your...
Expert SQL Server 2008 Encryption (Paperback)Michael Coles (Author), Rodney Landrum (Author)Link to Amazon“What is your...
29 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQL SERVER – Understanding Table Hints with Examples
IntroductionToday we have a very interesting subject to look at. I tried to look for help online but have not found any other...
IntroductionToday we have a very interesting subject to look at. I tried to look for help online but have not found any other...
30 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Joins
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Joinspinaldave posted a blog entry
SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table
It is very easy to find out some basic details of any table using the following Stored Procedure.USE AdventureWorksGOEXEC...
It is very easy to find out some basic details of any table using the following Stored Procedure.USE AdventureWorksGOEXEC...
31 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, Readers..., SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, Readers..., SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren
Script of Backup, Integrity Check and Index Optimization are the most important scripts for any developer. SQL Expert and true...
Script of Backup, Integrity Check and Index Optimization are the most important scripts for any developer. SQL Expert and true...
32 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL...pinaldave posted a blog entry
SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle
Update: Do not forget to checkout last three photos and follow me on twitter (of course!)I have previously documented my...
Update: Do not forget to checkout last three photos and follow me on twitter (of course!)I have previously documented my...
pinaldave posted a blog entry
SQL SERVER – Whitepaper Consolidation Using SQL Server 2008
Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server...
Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server...
34 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Server
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Serverpinaldave posted a blog entry
SQLAuthority News – Disk Partition Alignment Best Practices for SQL Server
Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often...
Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often...
35 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Best..., SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Best..., SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
IntroductionThis article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the...
IntroductionThis article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the...
36 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Database, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Database, Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint
Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when required. This type of...
Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when required. This type of...
37 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...pinaldave posted a blog entry
SQL SERVER – Sharepoint Resource Available for SQL Server
Here is quick list of the tools which are available for SQL Server and Sharepoint. These are recently updated resources from...
Here is quick list of the tools which are available for SQL Server and Sharepoint. These are recently updated resources from...
38 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL..., SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL..., SQL Querypinaldave posted a blog entry
SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
This is very short note announcing details about my course details for ‘MS SQL Server 2005/2008 Query Optimization And...
This is very short note announcing details about my course details for ‘MS SQL Server 2005/2008 Query Optimization And...
39 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Index
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Indexpinaldave posted a blog entry
SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes
Recently, I have been working on Query Optimization project. While working on it, I found the following interesting...
Recently, I have been working on Query Optimization project. While working on it, I found the following interesting...
40 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Index
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Indexpinaldave posted a blog entry
SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
During the PASS summit, one of the attendees asked me the following question.Why the Stored Procedure takes long time to run...
During the PASS summit, one of the attendees asked me the following question.Why the Stored Procedure takes long time to run...
41 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Interview Questions and...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Interview Questions and...pinaldave posted a blog entry
SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of...
The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of...
42 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Data...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Data...pinaldave posted a blog entry
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4
Fourth day was awesome. I had scheduled nearly 8 meetings with different groups of people today. It was really really fun. Let...
Fourth day was awesome. I had scheduled nearly 8 meetings with different groups of people today. It was really really fun. Let...
pinaldave posted a blog entry
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
Third day at SQL PASS Summit was for me education + entertaining day. During last 10 days I was getting up everyday at 4:00...
Third day at SQL PASS Summit was for me education + entertaining day. During last 10 days I was getting up everyday at 4:00...
pinaldave posted a blog entry
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2
The second day of PASS started with very engaging and it started with an original game invented by Stuart Ainsworth. This game...
The second day of PASS started with very engaging and it started with an original game invented by Stuart Ainsworth. This game...
pinaldave posted a blog entry
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 1
Day 1 at PASS was awesome. I have decided to cover this event little bit differently and with lots of images. In day 1 only I...
Day 1 at PASS was awesome. I have decided to cover this event little bit differently and with lots of images. In day 1 only I...
pinaldave posted a blog entry
SQLAuthority News – 3 Year Old Blog – PASS Summit 2009 – 10.5 Million Views
This blog has reached a remarkable milestone. It is 3 years old today. So far, there have been more than 10.5 million views on...
This blog has reached a remarkable milestone. It is 3 years old today. So far, there have been more than 10.5 million views on...
47 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQL Authority News – Advanced T-SQL with Itzik Ben-Gan – Solid Quality Mentors
As mentioned earlier in a blog post SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True, I got the...
As mentioned earlier in a blog post SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True, I got the...
Related topics
database
Pinal Dave
SQL
SQL Authority
SQLAuthority Author Visit
SQLAuthority News
SQL Index
sqlOptimization
SQL Performance
sql scripts
sqlserver
SQL Tips and Tricks
SQL White Papers
technology
T-SQL
Top members tagged
