Store unicode data in Sql Server

Posted by Sqltimes
On November 12, 2012
0 Comments

Sql Server allows storing unicode data using appropriate datatypes i.e. NVARCHAR, etc. But we can also store unicode data in non-unicode data types by specifying COLLATE keyword too. Important point here is, no matter what method you use, you must specify ‘N’ before the unicode literal in your INSERT statements. Example: [sourcecode language=”sql”] CREATE TABLE […]

Posted by Sqltimes
On November 11, 2012
0 Comments

Today, we will look at one of the obscure functions of Sql Server. It is quite useful in certain situations. FILEPROPERTY: This function allows us to query certain properties of a given database file. For example: Space Used Is this a Primary file or a Log file …etc [sourcecode language=”sql”] USE [tempdb] GO SELECT FILEPROPERTY(‘tempdev’, […]

Posted by Sqltimes
On November 10, 2012
0 Comments

Today, we will look at one of the obscure built-in procedures in Sql Server. There is not much documentation that I could find on this, except a couple of other blog posts. May be for a good reason, but here it is. [sourcecode language=”sql”] EXEC xp_fixeddrives GO [/sourcecode] Gives you the free space available on […]

Posted by Sqltimes
On November 4, 2012
0 Comments

CDC (Change Data Capture) is a pretty robust technology. We’ve been using it for a while now and it works great. As it is built on top of another established robust technology Replication, I was more confident to continue using it in our production environment. One aspect of CDC that has consumed a little more […]

Posted by Sqltimes
On November 4, 2012
0 Comments

This is one of the most frequent questions during performance tuning (or during the maintenance plan discussions). There is a quick way to check this for all the STATISTICS on all tables. The function STATS_DATE returns the date when the stats were recomputed. Example: [sourcecode language=”sql”] SELECT OBJECT_NAME(object_id) AS [Table_Name] , STATS_DATE(object_id, stats_id) AS [State_Updated_Date] , […]

Store unicode data in Sql Server

Sql Server Function: FILEPROPERTY

Sql Server procedure xp_fixeddrives

Sql Server: CDC (Change Data Capture) Configure Retention period

Sql Server: When was the last time STATISTICs were updated on a table