ranjithk
Name: ranjithk
Score: 185.01
Last Seen: 760 days, 16 hours, 40 minutes ago
Member Since: 23 April, 2010
SqlServerKudos
atom rss
1
kudos
spam Kudos Remove

Understanding SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF « ranjithk's blog

published 754 days, 2 minutes ago posted by ranjithkranjithk 760 days, 23 hours, 41 minutes ago
Friday, April 30, 2010 8:35:11 AM GMT Friday, April 23, 2010 8:55:55 AM GMT
These are the two widely used SET options in SQL Server. Most developers explicitly set these options while creating Stored Procedures, Triggers and User Defined Functions but many are unclear on why we need explicitly SET them? and Why these two are special compared to other options? (more)
category: Analysis | clicked: 2 | comment | | source: ranjithk.com
1
kudos
spam Kudos Remove

How to get the File Group of a Table or an Index? « ranjithk's blog

published 754 days, 2 minutes ago posted by ranjithkranjithk 760 days, 23 hours, 42 minutes ago
Friday, April 30, 2010 8:35:11 AM GMT Friday, April 23, 2010 8:54:39 AM GMT
The file group information of both an Index and a Table are stored in the sys.indexes table. You might wonder how the tables file group is stored in sys.indexes metadata table. It is because when ever a clustered index is created ... (more)
category: Query | clicked: 1 | comment | | source: ranjithk.com
1
kudos
spam Kudos Remove

Script to drop all objects of a Schema in SQL Server « ranjithk's blog

published 754 days, 2 minutes ago posted by ranjithkranjithk 760 days, 23 hours, 43 minutes ago
Friday, April 30, 2010 8:35:11 AM GMT Friday, April 23, 2010 8:53:47 AM GMT
The script initially drops all the objects of the schema and then drops the schema itself. It takes care of all the object dependencies with in the schema by dropping all of them in a specific order that will resolve the dependency issues (more)
category: Query | clicked: 3 | comment | | source: ranjithk.com
1
kudos
spam Kudos Remove

Dynamically getting the execution status of a SQL Server Agent Job « ranjithk's blog

published 754 days, 2 minutes ago posted by ranjithkranjithk 760 days, 23 hours, 57 minutes ago
Friday, April 30, 2010 8:35:11 AM GMT Friday, April 23, 2010 8:39:35 AM GMT
Dynamically retrieving the SQL Server Agent Job Status. (more)
category: Query | clicked: 3 | comment | | source: ranjithk.com