Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

↑

tsql,sql server - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » tsql » sql server (RSS)
12 March 2008 08:10

TSQL to change collation of database, whats new in SQL 2008 then?

How can you change collation of a database? How do you check the existing collation setup on a database & tables? By using the below TSQL: --For database select databasepropertyex(db_name(),'collation') as collation_name go --Tables select column_name...
Posted by ssqa.net | 1 comment(s)
Filed under: , , , , , , , , , ,
10 March 2008 07:09

SQL Server scrollable server cursors, use them carefully!

One sentence, if you haven't used the Cursors sensibly then database performance will be cursed! This is for newbie users and DBAs to be aware that on general recommendation is server side cursors are better than client side one, in this you need to be...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , , , ,