|
|
-
|
|
Here comes another b'day of mine!! I just felt like I celebrated my last b'day just a couple months ago :) Time is moving so fast and so is the world.B'day reminds me of my childhood days (especially when I was in primary school) when I used to get new clo...
|
|
-
|
|
Technology,networking,knowledge sharing under one roof and that too for 3 consecutive days !!! Wow,thats TechEd for you.
[Picture courtesy - http://yodigo-contrablog.blogspot.com]
TechEd India 2012 gave me a fabulous ride this time.Even though I couldn...
|
|
-
|
|
This post is really inspired by Nakul's wonderful post: http://beyondrelational.com/blogs/nakul/archive/2011/12/29/sql-server-t-sql-different-ways-to-generate-a-comma-separated-string-from-a-table.aspx
However, Whenever I faced a situation to concatenate the values in a table there was always a req......
|
|
-
|
|
This is by far the simplest and silliest post ever, but i just figured how to create vertical tabs in management studio. When I learn something, you have to read it. I apologize, but you have to read it. As Ellen DeGeneres says, “if I see something… you...
|
|
-
|
|
I have been doing some research with DBM(Database Mirroring) repair features and today I came across this little tricky situation and decided to write about it.Scenario is something like below -
1. I tried to setup mirroring on a virtual environment and t...
|
|
-
|
|
I’ve played with SQL Server Denali and found some new features and improvements in Query Execution plan. My intention was to test Extended Events and new events: sort_warning and hash_warnig. In SQL Server 2008R2, we can create SQL Trace to capture sort and hash warnings but there is no easy w......
|
|
-
|
|
A few weeks back a client of mine asked me to write a script that could tell him the space used by write only indexes. The usage stats from the indexes is pretty easy to get from ‘sys.dm_db_index_usage_stats’ and if you join the DMV ‘sys.dm_db_partition_stats’ onto that, you can from the column ‘use......
|
|
-
|
|
As I am tweeting around the facts on Nulls for last couple of days, I thought of writing a blog on that as many of you have already requested me on this regard. This post is basically dealing with Nulls and will go through only with basic C# stuffs, so for geeks, it is not recommended and you might......
|
|
-
|
|
In a varchar column some of the entries were showing space in the left side and even after using the LTRIM it was not getting removed. When I tried to print the first character using the ASCI function it was showing 13 which is a new line character. it ca...
|
|
-
|
|
I received the following message from a Developer. The message was on a Test SQL Server.
“NC_myIndex " on table "VeryLargeTable" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.
The cause of the message was that the index was disabled. I discovered th......
|
|