Sql Server Function FORMAT to format currency, strings, text and numbers for different cultures

Posted by Sqltimes
On October 31, 2014
0 Comments

Quick one today: Sql Server has interesting functions; Today we’ll look at one. Let’s start with a simple example: 1 2 3 4 5 -- -- FORMAT function with integer -- SELECT FORMAT(12312312,'#,###,###,###,###') GO Result: 1 2 3 4 5 6 7 8 9 -- -- FORMAT function with date -- DECLARE @DT DATETIME […]

Posted by Sqltimes
On October 26, 2014
0 Comments

In troubleshooting some issues with databases, sometimes you need to capture server side traces. Sometimes Profiler could help capture specific events as needed. Another option is to use the server side stored procedures to capture trace into a file. There are several points to keep in mind when you run server side traces, but for […]

Posted by Sqltimes
On October 24, 2014
0 Comments

Recently, at one of our customer sites, we noticed this interesting anomaly. In this database, there are several tables and each table has several statistics. Statistics could be created in several ways. Index based statistics Column Statistics User created Auto created Statistics (that are created by Sql Server) Problem When they perform nightly maintenance, some […]

Sql Server Function FORMAT to format currency, strings, text and numbers for different cultures

Sql Server Start, Stop, Delete server side trace using t-sql

Sql Server: Update ‘Auto Created’ Statistics and all statistics on a table