Topic: Pinal Dave
New with Topic: Pinal Dave
pinaldave posted a blog entry
SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture
Few days ago, I got the great opportunity to visit Bangalore Infosys. Please read the complete details for the event here:...
Few days ago, I got the great opportunity to visit Bangalore Infosys. Please read the complete details for the event here:...
12 hours 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 – ORDER BY Clause and TOP WITH TIES
Recently, on this blog, I published an article on SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY; this...
Recently, on this blog, I published an article on SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY; this...
3 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 – Meeting SQL Expert Imran at Hyderabad
I was very fortunate to meet the SQL Server Expert and one of the top participants of this blog Imran Mohammed. Imran has been...
I was very fortunate to meet the SQL Server Expert and one of the top participants of this blog Imran Mohammed. Imran has been...
pinaldave posted a blog entry
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2
In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV)...
In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV)...
5 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 – Migrating to SQL Server from Other Database Products
Guide to Migrating from MySQL to SQL Server 2008In this migration guide you will learn the differences between the MySQL and...
Guide to Migrating from MySQL to SQL Server 2008In this migration guide you will learn the differences between the MySQL and...
7 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 – 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...
8 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Business..., DBA, Database, Pinal Dave
Journey to SQL Authority with Pinal Dave
| Topics: Business..., DBA, Database, Pinal Davepinaldave 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...
10 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...
11 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...
12 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 – 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...
13 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...
15 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...
16 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 – 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...
17 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:...
18 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...
19 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...
20 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...
22 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...
23 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...
24 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 – 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....
26 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...
29 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 – 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...
31 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...
32 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 – 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...
33 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...
34 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...
36 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...
37 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...
38 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...
39 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 – 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...
43 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...
44 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 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...
46 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...
47 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...
48 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...
49 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...
54 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...
pinaldave posted a blog entry
SQLAuthority News – New PASS President Rushabh Mehta
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting,...
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting,...
pinaldave posted a blog entry
SQLAuthority News – India Market and Third Party SQL Server Tools
Last week, I had wonderful time attending meeting of small ISV (Independent Software Vendors). Several topics were discussed,...
Last week, I had wonderful time attending meeting of small ISV (Independent Software Vendors). Several topics were discussed,...
57 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 – Birds-of-a-Feather (BOF) Lunch – SQL PASS Summit, Seattle, 2009
I received few emails regarding where can people meet me at SQL PASS event in Seattle. I am currently in Bellevue attending...
I received few emails regarding where can people meet me at SQL PASS event in Seattle. I am currently in Bellevue attending...
pinaldave posted a blog entry
SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’
Many times I have seen that the index is disabled when there is large update operation on the table. Bulk insert of very large...
Many times I have seen that the index is disabled when there is large update operation on the table. Bulk insert of very large...
60 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 Index