SqlServerKudos - Stories tagged with SQLServer

SQLServer

atom rss
1
kudos
spam Kudos Remove

Queue table processing in SQL Server | AdaTheDev
published 803 days, 6 hours, 26 minutes ago posted by AdaTheDevAdaTheDev 812 days, 3 hours, 34 minutes ago
Thursday, March 11, 2010 5:56:40 AM GMT Tuesday, March 02, 2010 8:49:00 AM GMT
Queue table processing in SQL Server | AdaTheDev
The scenario is you queue up records in a database table, each representing a piece of work needing to be done. You then want to have processes that periodically poll this table to pick up the next item of work from the queue and process them. (more)
category: Query | clicked: 3 | comment | | source: www.adathedev.co.uk
tags: SQL, SQLServer
1
kudos
spam Kudos Remove

Changing primary key index structure | AdaTheDev
published 805 days, 6 hours, 36 minutes ago posted by AdaTheDevAdaTheDev 812 days, 22 hours, 57 minutes ago
Tuesday, March 09, 2010 5:46:46 AM GMT Monday, March 01, 2010 1:25:24 PM GMT
Changing primary key index structure | AdaTheDev
Changing the structure of a primary key constraint index from nonclustered to clustered (or from clustered to nonclustered) is not necessarily as straight forward as it first seems. The process of changing it over, involves the constraint being dropped and then recreated. This could potentially cause a problem if you're making the change on a table whilst there could be activity against it. (more)
category: Management | clicked: 3 | comment | | source: www.adathedev.co.uk
tags: Indexes, SQL, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave
published 814 days, 7 hours, 16 minutes ago posted by pinaldavepinaldave 824 days, 3 hours, 47 minutes ago
Sunday, February 28, 2010 5:06:08 AM GMT Thursday, February 18, 2010 8:35:26 AM GMT
SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave
We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra i... (more)
category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: database, pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave
published 824 days, 7 hours, 58 minutes ago posted by pinaldavepinaldave 831 days, 23 hours, 10 minutes ago
Thursday, February 18, 2010 4:24:37 AM GMT Wednesday, February 10, 2010 1:12:09 PM GMT
SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave
I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave
published 858 days, 13 hours, 42 minutes ago posted by pinaldavepinaldave 864 days, 21 hours, 40 minutes ago
Thursday, January 14, 2010 10:40:40 PM GMT Friday, January 08, 2010 2:42:51 PM GMT
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave
In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that was discussed on show was about the usage of function SUBSTRING. I found the following point very valid: SUBSTRING usage limits the length of the XML to be used. I have re-written the same function with function STUFF, and it removes a... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer, XML
1
kudos
spam Kudos Remove

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server « Journey to SQL Authority with Pinal Dave
published 859 days, 13 hours, 47 minutes ago posted by pinaldavepinaldave 868 days, 8 hours, 58 minutes ago
Wednesday, January 13, 2010 10:35:43 PM GMT Tuesday, January 05, 2010 3:24:58 AM GMT
SQL SERVER – Differences in Vulnerability between Oracle and SQL Server « Journey to SQL Authority with Pinal Dave
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below:A. Microsoft development platforms are generally more error-prone and full of bugs. This (unfairly) projects the weaknesses of Microsoft’s best-known product Windows onto its other products such as SQL Server, which is a very stable and se... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth « Journey to SQL Authority with Pinal Dave
published 879 days, 15 hours, 15 minutes ago posted by pinaldavepinaldave 888 days, 17 hours, 54 minutes ago
Thursday, December 24, 2009 9:08:01 PM GMT Tuesday, December 15, 2009 6:28:16 PM GMT
SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth « Journey to SQL Authority with Pinal Dave
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 following: Temp Table and Table Variable — both are created in TempDB and not in memory. Let us prove this concept by running the following T-SQL script. /* Check the difference between Temp Table... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
published 886 days, 15 hours, 45 minutes ago posted by sasa 896 days, 3 hours, 57 minutes ago
Thursday, December 17, 2009 8:37:44 PM GMT Tuesday, December 08, 2009 8:25:15 AM GMT
Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
One of the SQL Server 2008 upgrade process hampered with the error on the subject line and following text box was displayed: For some reason the similar issue hasn't been displayed when Upgrade Advisor has been chosen to find the first hand issues, as per http://sqlserver-qa.net/blogs/tools/archive/2008/01/22/upgrade-blurg.aspx and http://sqlserver-qa.net/blogs/tools/archive/tags/upgrade+advisor/default.aspx posts here. Coming to the root cause of the issue one of the KBA refers that .... this issue...(r... (more)
category: News | clicked: 3 | 2 comments | | source: sqlserver-qa.net
tags: access, policy based framework, sa, Security, SQL Server 2008, SQLServer, Upgrade, upgrade advisor
1
kudos
spam Kudos Remove

SQL SERVER – Azure Start Guide – Step by Step Installation Guide « Journey to SQL Authority with Pinal Dave
published 892 days, 16 hours, 11 minutes ago posted by pinaldavepinaldave 902 days, 8 hours, 28 minutes ago
Friday, December 11, 2009 8:11:37 PM GMT Wednesday, December 02, 2009 3:54:36 AM GMT
SQL SERVER – Azure Start Guide – Step by Step Installation Guide « Journey to SQL Authority with Pinal Dave
As SQL Azure CTP is released I have included here step by step guide for how to configure the CTP. For pricing and introduction please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing First it has to be configured online at https://sql.azure.com/ Login using your Live ID Type in invitation code received from Microsoft for CTP. You can request one for your self here. Accept the TOU. Once logged it you will have to create server username and password. ... (more)
category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Comma Separated Values (CSV) from Table Column « Journey to SQL Authority with Pinal Dave
published 899 days, 16 hours, 37 minutes ago posted by pinaldavepinaldave 908 days, 19 hours, 7 minutes ago
Friday, December 04, 2009 7:45:26 PM GMT Wednesday, November 25, 2009 5:15:04 PM GMT
SQL SERVER – Comma Separated Values (CSV) from Table Column « Journey to SQL Authority with Pinal Dave
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 -- Check Table Column SELECT Name FROM HumanResources.Shift GO -- Get CSV values SELECT SUBSTRING( (SELECT ',' + s.Name FROM HumanResources.Shift s ORDER BY s.Name FOR XML PATH('')),2,2000... (more)
category: Query | clicked: 1 | 1 comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index « Journey to SQL Authority with Pinal Dave
published 900 days, 16 hours, 42 minutes ago posted by pinaldavepinaldave 910 days, 8 hours, 15 minutes ago
Thursday, December 03, 2009 7:40:29 PM GMT Tuesday, November 24, 2009 4:07:07 AM GMT
SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index « Journey to SQL Authority with Pinal Dave
In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature and I use this feature every now and then. The question is does the change of any column as Primary Key should also create a Clustered Index? Moreover, is there any case, where one would not do the same? One of the recent conversations I had with one SQL Expert is with regard to the SSN number. The discussion was that SSN numbers are always unique and never repeated and hence ... (more)
category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY « Journey to SQL Authority with Pinal Dave
published 900 days, 16 hours, 42 minutes ago posted by pinaldavepinaldave 910 days, 8 hours, 21 minutes ago
Thursday, December 03, 2009 7:40:29 PM GMT Tuesday, November 24, 2009 4:01:45 AM GMT
SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY « Journey to SQL Authority with Pinal Dave
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, unless TOP or FOR XML is also specified. The error also explains the solution for the same – use of TOP. I have seen developers and DBAs using TOP very causally when they have to use the O... (more)
category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Difference Between Candidate Keys and Primary Key « Journey to SQL Authority with Pinal Dave
published 927 days, 18 hours, 41 minutes ago posted by pinaldavepinaldave 937 days, 13 hours, 34 minutes ago
Friday, November 06, 2009 5:41:40 PM GMT Tuesday, October 27, 2009 10:48:09 PM GMT
SQL SERVER – Difference Between Candidate Keys and Primary Key « Journey to SQL Authority with Pinal Dave
Introduction Not long ago, I had an interesting and extended debate with one of my friends regarding which column should be primary key in a table. The debate instigated an in-depth discussion about candidate keys and primary keys. My present article revolves around the two types of keys. Let us first try to grasp the definition of the two keys. Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Key... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

BUG - Use of ranking functions result in an inefficient query plan - SQL and the like
published 976 days, 23 hours, 10 minutes ago posted by sasa 986 days, 11 hours, 37 minutes ago
Friday, September 18, 2009 1:12:05 PM GMT Wednesday, September 09, 2009 12:45:40 AM GMT
BUG - Use of ranking functions result in an inefficient query plan - SQL and the like
BUG - Use of ranking functions result in an inefficient query plan In SQL2005 (9.00.4207.00), if you use a ranking function within a view or CTE, then an inefficient query plan can be produced. First off in Adventure works create this index Create Index idxLastName on Person.Contact(LastName) and then consider these similar queries:select ContactId, LastName, row_number() over(partition by LastName order by ContactId) from [AdventureWorks].[Person].[Contact] where LastName = 'Smith' go create ... (more)
category: News | clicked: 2 | comment | | source: sqlblogcasts.com
tags: SQLServer, TSQL
2
kudos
spam Kudos Remove

SQL SERVER – Introduction to Cloud Computing « Journey to SQL Authority with Pinal Dave
published 1022 days, 40 minutes ago posted by pinaldavepinaldave 1024 days, 6 hours, 29 minutes ago
Tuesday, August 04, 2009 11:42:41 AM GMT Sunday, August 02, 2009 5:53:49 AM GMT
SQL SERVER – Introduction to Cloud Computing « Journey to SQL Authority with Pinal Dave
Introduction “Cloud Computing,” to put it simply, means “Internet Computing.” The Internet is commonly visualized as clouds; hence the term “cloud computing” for computation done through the Internet. With Cloud Computing users can access database resources via the Internet from anywhere, for as long as they need, without worrying about any maintenance or management of actual resources. Besides, databases in cloud are very dynamic and scalable. Cloud computing is unlike grid computing, utility computin... (more)
category: News | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQLAuthority, SQLServer
2
kudos
spam Kudos Remove

SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table « Journey to SQL Authority with Pinal Dave
published 1023 days, 31 minutes ago posted by pinaldavepinaldave 1027 days, 3 hours, 47 minutes ago
Monday, August 03, 2009 11:51:18 AM GMT Thursday, July 30, 2009 8:35:17 AM GMT
SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table « Journey to SQL Authority with Pinal Dave
Just about a year ago, I had written on the subject of how to insert data from one table to another table without generating any script or using wizard in my article SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE. Today, we will go over a similar question regarding how to generate script for data from database as well as table. SQL Server 2008 has simplified everything. Let us take a look at an example where we will generate script database. In our exam... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
published 1029 days, 17 minutes ago posted by pinaldavepinaldave 1029 days, 5 hours, 58 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Tuesday, July 28, 2009 6:24:13 AM GMT
SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
The best part of any blog is when readers ask each other questions. Better still, is when a reader takes the time to provide a detailed response. A few days ago, one of my readers, Yasmin, asked a very interesting question: How we can find the list of tables whose identity was missed (not is sequential order) within the entire database? A big thank you to SQL Server Expert, Imran Mohammed, for his excellent response to this question. He also provided an extremely impressive script, which is well descr... (more)
category: Management | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
published 1028 days, 11 minutes ago posted by pinaldavepinaldave 1030 days, 1 hour, 10 minutes ago
Wednesday, July 29, 2009 12:11:04 PM GMT Monday, July 27, 2009 11:12:30 AM GMT
SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
The best part of any blog is when readers ask each other questions. Better still, is when a reader takes the time to provide a detailed response. A few days ago, one of my readers, Yasmin, asked a very interesting question: How we can find the list of tables whose identity was missed (not is sequential order) within the entire database? A big thank you to SQL Server Expert, Imran Mohammed, for his excellent response to this question. He also provided an extremely impressive script, which is well descr... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
Previous 1 2 3 Next