Sql Server : Partition function ‘%1’ uses %2 columns which does not match with the number of partition columns used to partition the table or index

Posted by Sqltimes
On April 30, 2014
0 Comments

Quick one today: A few days go, as part of implementing table partitioning, I ran into this interesting error. 1 2 Msg 2726, Level 16, State 1, Line 1 Partition function 'pf_SampleTable' uses 1 columns which does not match with the number of partition columns used to partition the table or index. At first glance, […]

Posted by Sqltimes
On April 26, 2014
0 Comments

Quick one today: Starting Sql Server 2008, we have a new way to declare variables and assign values. Earlier we used to use DECLARE statement to declare variables and then in a separate statement, using SET or SELECT statement, assign values to them. Sql Server 2008 combines them to make it easy. Let’s take an […]

Posted by Sqltimes
On April 23, 2014
0 Comments

Quick one today: Sometimes, but not too often (thank fully), we end up in situations where we need to KILL some processes (SPIDs). There are several reasons for this. Either a long running query (that is just SELECTing) Query that is blocking other processes Query is has been in waiting state for a long while, […]

Posted by Sqltimes
On April 19, 2014
0 Comments

Quick one today: In the last few weeks, there have been multiple incidents where there was a need to remove/add/modify data files on a Sql Server databaes. So, it is time to add it as a new post. Altering data files to a database is made easier in newer versions of Sql Server. Add […]

Posted by Sqltimes
On April 15, 2014
0 Comments

Quick one today: A few days ago, one of your customers, upon request, sent us their Perfmon files from their database server. We have a template to capture all pertinent Sql Server metrics from PerfMon that we provide to all our customers. When needed we request them to enable the process and let it capture […]

Posted by Sqltimes
On April 12, 2014
0 Comments

Quick one today: Temporary tables and table variables are a great addition in Sql Server. Pretty much every database code take advantage of this feature, for right reasons. Now, with this increased usage, comes responsibility to do two things: Use the feature correctly & efficiently Create efficiencies in TempDB database. Keep in mind that for Indexes […]

Posted by Sqltimes
On April 9, 2014
0 Comments

Sql Server, starting from 2005, has extensive methods to parse, slice & dice XML files. Before that, for DBA’s, XML is not a favorite topic — especially from T-SQL point of view. Application languages like C#, ASP.Net and Java have many methods and programmers usually prefer to handle XML in application code rather than T-SQL. […]

Posted by Sqltimes
On April 6, 2014
0 Comments

Quick one today: Once in a while we all need to capture SQL traces from production or development database server and need to analyze it. Sql Trace files is a binary files that could be opened in Sql Profiler. Often times, it is easier to analyze the trace thoroughly when you load the data into […]

Posted by Sqltimes
On April 5, 2014
0 Comments

Quick one today: For every Sql Server release, Microsoft provides this free ebook that is very useful to improve our understanding of the new features. Below is the ebook for Sql Server 2014. Hope you enjoy reading it just as much. Here is the link: Sql Server 2014 Free e-book. Hope this helps, _Sqltimes

Sql Server : Partition function ‘%1’ uses %2 columns which does not match with the number of partition columns used to partition the table or index

Sql Server: Variable declaration, assignment and precedence

Sql Server Kill a SPID (session or Process)

Sql Server: How to remove existing data files

Convert PerfMon blg files into csv

Sql Server: Some differences between Temp tables and Table variables

Sql Server: OPENXML (sample T-SQL querying techniques using OPENXML)

Sql Server : How to read Sql Profiler trace files into a SQL table

Sql Server 2014 : Free ebook from microsoft