SQL Scripts
Tag details
Welcome to the 'SQL Scripts' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'SQL Scripts'.
Latest blogosphere posts tagged “SQL Scripts”
-
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
Journey to SQL Authority with Pinal Dave —
Authority: 541
I would like to start this post with an interesting question: Where in MS SQL Server is “100” equals to “0”? And I am not talking about data types now.. Today I will be presenting the answer to this question and some topics related to it. Creating Indices in SQL Server is one of the most important ...5 days ago -
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
Visit SQLAuthority.com —
Authority: 128
I would like to start this post with an interesting question: Where in MS SQL Server is “100” equals to “0”? And I am not talking about data types now.. Today I will be presenting the answer to this question and some topics related to it. Creating Indices in SQL Server is one of the most important ...5 days ago -
SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth
Journey to SQL Authority with Pinal Dave —
Authority: 541
Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp table and table variable, I quite commonly hear that Table Variables are stored in memory and Temp Tables are stored in TempDB. I would like to bust this misconception by suggesting ...6 days ago -
SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth
Visit SQLAuthority.com —
Authority: 128
Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp table and table variable, I quite commonly hear that Table Variables are stored in memory and Temp Tables are stored in TempDB. I would like to bust this misconception by suggesting ...6 days ago -
SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication
Journey to SQL Authority with Pinal Dave —
Authority: 541
Replication has been my favorite subject when it comes to resolving errors. I have found that many DBAs are stuck with the solving of the problem of replication for hours; however, the solution is very easy. One of the very common errors in replication occurs when replication is removed from any server. I have seen ...1 week ago -
SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication
Visit SQLAuthority.com —
Authority: 128
Replication has been my favorite subject when it comes to resolving errors. I have found that many DBAs are stuck with the solving of the problem of replication for hours; however, the solution is very easy. One of the very common errors in replication occurs when replication is removed from any server. I have seen ...1 week ago -
SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore
Journey to SQL Authority with Pinal Dave —
Authority: 541
I recently had opportunity to attend TechDays 2009 Infosys. This event was the largest technology conference by Microsoft in Infosys. Microsoft Tech Days focused on positioning Microsoft as the company to bet on for future technology investments by businesses and consumers alike. The event was a showcase of ...2 weeks ago -
SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore
Visit SQLAuthority.com —
Authority: 128
I recently had opportunity to attend TechDays 2009 Infosys. This event was the largest technology conference by Microsoft in Infosys. Microsoft Tech Days focused on positioning Microsoft as the company to bet on for future technology investments by businesses and consumers alike. The event was a showcase of ...2 weeks ago -
SQL SERVER – Validate an XML document in TSQL using XSD by Jacob Sebastian
Journey to SQL Authority with Pinal Dave —
Authority: 541
Following article is sent by SQL Server MVP Jacob Sebastian on request to provide solution for validating XML document. XML Schema Collections Because of the ‘eXtensible’ nature of XML (eXtensible Markup Language), often there is a requirement to restrict and validate the content of an XML document to a ...2 weeks ago -
SQL SERVER – Validate an XML document in TSQL using XSD by Jacob Sebastian
Visit SQLAuthority.com —
Authority: 128
Following article is sent by SQL Server MVP Jacob Sebastian on request to provide solution for validating XML document. XML Schema Collections Because of the ‘eXtensible’ nature of XML (eXtensible Markup Language), often there is a requirement to restrict and validate the content of an XML document to a ...2 weeks ago -
SQL SERVER – Size of Index Table for Each Index – Solution
Journey to SQL Authority with Pinal Dave —
Authority: 541
Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution. Please read the original Puzzle here. SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table The puzzle was to write a query that will return the size ...3 weeks ago -
SQL SERVER – Size of Index Table for Each Index – Solution
Visit SQLAuthority.com —
Authority: 128
Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution. Please read the original Puzzle here. SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table The puzzle was to write a query that will return the size ...3 weeks ago -
SQL SERVER – Comma Separated Values (CSV) from Table Column
Journey to SQL Authority with Pinal Dave —
Authority: 541
I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma Separated Values (CSV) from Table Column is a very common task, and we all do this many times a day. Let us see the example that I use frequently and its output. USE AdventureWorks GO ...3 weeks ago -
SQL SERVER – Comma Separated Values (CSV) from Table Column
Visit SQLAuthority.com —
Authority: 128
I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma Separated Values (CSV) from Table Column is a very common task, and we all do this many times a day. Let us see the example that I use frequently and its output. USE AdventureWorks GO -- ...3 weeks ago -
SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY
Journey to SQL Authority with Pinal Dave —
Authority: 541
Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while creating any view: Msg 1033, Level 15, State 1, Procedure something, Line 5 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, ...3 weeks ago -
SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY
Visit SQLAuthority.com —
Authority: 128
Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while creating any view: Msg 1033, Level 15, State 1, Procedure something, Line 5 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, ...3 weeks ago -
SQL SERVER – Understanding Table Hints with Examples
Journey to SQL Authority with Pinal Dave —
Authority: 541
Introduction Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how they are helpful. What is a Hint? ...4 weeks ago -
SQL SERVER – Understanding Table Hints with Examples
Visit SQLAuthority.com —
Authority: 128
Introduction Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how they are helpful. What is a Hint? ...4 weeks ago -
SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table
Journey to SQL Authority with Pinal Dave —
Authority: 541
It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of all ...4 weeks ago -
SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table
Visit SQLAuthority.com —
Authority: 128
It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of ...4 weeks ago
