Viewing 15 posts - 18,196 through 18,210 (of 19,560 total)
This may be suitable for your needs.
Select 'Select count(*) From ' + table_name + ' where [' + column_name + '] is null;' from information_schema.columns
Select 'Select count(*) From '...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 6:23 pm
What is your criteria for determining if a column is used or not within a table? If it is null?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 6:02 pm
Doh - posted this in the wrong thread
Some lite reading:
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/02/some-vldb-availability-tidbits.aspx
http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 5:07 pm
Some lite reading:
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/02/some-vldb-availability-tidbits.aspx
http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 5:06 pm
This might be of assistance.
http://www.mssqltips.com/tip.asp?tip=1172
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 4:58 pm
Try this one
http://vyaskn.tripod.com/scripting_permissions_in_sql_server_2005.htm
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 4:56 pm
The most obstinate of my children is my daughter. 11 months old is all. But that is fine.:-)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 4:18 pm
Lynn Pettis (1/12/2010)
crookj (1/12/2010)
CirquedeSQLeil (1/12/2010)
BurritoMake that a steak burrito from Chipotles (lunch today)
Joe
Chicken Fajita Burrito. That was lunch yesterday at Chipolte.
Yum - now I need to find Chipotle...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 1:09 pm
noeld (1/12/2010)
You shouldn't be using status bits directly the translations are mostly spread out into separated columns now for easier use.That said:
Nice script and thanks for the reference Noel.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 12:09 pm
Out of curiosity, now that you are able to remove the public role permissions. Do you have a plan in place or substitute role in place should issues arise...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 11:58 am
Tara-1044200 (1/12/2010)
I gave my expected result above.I have a column which has week number like 1 to 52 but i want to update them with prefix year like 2009.1,2009.2......2009.52
I agree...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 11:55 am
Las Vegas, Nevada
Moved here 5 months ago from Grantsville, Utah
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 11:50 am
Subhash-63067 (1/12/2010)
I need feedback on using EMC Legato for taking SQL Server backup. Can somebody share the good / pain points around that please?
1. Does the Legato Full backup...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 10:52 am
I would run a DBCC CheckDB against each of the databases in question (torn page, or status that you are uncertain about).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 10:38 am
is250sp (1/12/2010)
WayneS (1/12/2010)
Is there any particular reason for going this method - specially since there is a way further on down that is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2010 at 10:16 am
Viewing 15 posts - 18,196 through 18,210 (of 19,560 total)