New Date and Time Data Types in SQL Server 2008
SQL Server 2008 introduces four new DATETIME data types as follows: DATE: – In Previous versions of SQL Server, we had to use the DATETIME or SMALLDATETIME data types even though …
Read MoreArchives: Posts
SQL Server: Use of ClearCache (XMLA) command in ROLAP partition without Proactive Caching
Hi Friends, Just wanted to share my experience on the role of cache while browsing the cube. I have attended one workshop on SSAS conducted by Mr. Amit Bansal in Mumbai. …
Read MoreSQL Server: Find out edition specific features that are enabled in current database – sys.dm_db_persisted_sku_features
Hi Friends, There is a way how you can find out any edition specific features that you are using in your current database. These edition-specific features may not be supported in …
Read Moresys.Databases vs sys.sysDatabases
Hi Friends, Just wanted to write a short note on what is the difference between sys.Databases and sys.sysDatabases. Well, both of them return some metadata related to databases hosted on the …
Read MoreControlling growth of msdb database caused by Database Mail
This should be the common issue faced by many of us where the database mail is used to send bulk mails on a regular basis. We have a database server which …
Read MoreSQL Server: Scripting Data along with Schema
Hello Friends, In this article i will show you how to script the table data along with schema of the table. This feature is given as a new option in the …
Read MoreHiding SQL Server Instance
Hello Friends, By default, we can see every instance of SQL Server on the network. The network broadcast is what enables the instance enumeration within various management tools where you can …
Read MoreSQL Server: Use of sp_MSForEachTable
Many a times we get into the situation where we need to do a specific task or run T-SQL Command for all tables in a Database. For Example: Disable all Check …
Read MoreSQL Multiply all values in a column
Hi, Most of you reading this blog must be aware that SQL Server has an aggregate function called SUM to add all the values in a column.But what if you want …
Read MoreSQL Server: Finding the Source database name/id against which Database Snapshot was created
Hi Friends, Interesting question – suppose a DBA has created a snapshot on a user database. You do not have access to the source/user database. You only have access to the …
Read More