Forum Replies Created
Viewing 15 posts - 18,556 through 18,570 (of 19,560 total)
-
RE: Question of the Day for 21 Dec 2009
Jeff Moden (12/21/2009)
BWAA-HAA!!! Frosty needs to get a set-based decoder ring! 😛DECLARE @ToAllGoodPeople TABLE(
...
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 -
RE: Transactions
Nice question Bitbucket.
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 -
RE: Are the posted questions getting worse?
Merry Christmas and Happy New Year to all
Nice pic Gail.
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 -
RE: Tracking Database data changes
Check this thread http://www.sqlservercentral.com/Forums/Topic294216-314-1.aspx#bm299093. It might be what you are looking for.
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 -
RE: Looking at someone elses code
Lynn Pettis (12/21/2009)
Jason is right, you don't have a WHERE clause to join the two tables in the second FROM clause (the UPDATE statements FROM clause). Are you sure...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 -
RE: Looking at someone elses code
Jeffrey Williams-493691 (12/21/2009)
CirquedeSQLeil (12/21/2009)
OK Jeff, what am I missing here - I see no code at all.Well - you're probably missing the ability to access the linked image. The...
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 -
RE: Color data type for SQL
There may be other methods - and it would certainly be worth testing. It seems to me that a char or varchar would work in this scenario.
Thanks for the...
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 -
RE: Create and Alter procedure without dbo permissions
Yes this would be feasible.
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 -
RE: Looking at someone elses code
Jeffrey Williams-493691 (12/21/2009)
Lynn Pettis (12/21/2009)
SQL Iron Chef (12/21/2009)
Lynn Pettis (12/21/2009)
SQL Iron Chef (12/21/2009)
You do know that the NOLOCK hint on the update is ignored, right?
Actually I didn't! I was just...
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 -
RE: Question of the Day for 21 Dec 2009
Thanks Steve. It only seems to happen every once in a while that the code doesn't copy so well from the QOD.
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 -
RE: Moving table data/index to diff file groups
You're welcome. Thanks for the feedback.
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 -
RE: Trace Flag 253
Unless this is something that PSS suggested be enabled for a specific issue, I would turn it off.
As a proof of concept, you may want to turn it off in...
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 -
RE: Database Admin support for DB's based in japan
IMHO #2 is the only one that changes somewhat. For #2 you will possibly be looking at language differences and character differences.
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 -
RE: Setup Bootstrap Folder
I typically remove this type of stuff. It seems to have no ill-effect and I have not been asked by PSS for these folders.
If you are concerned about them,...
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 -
RE: SS 2005 Network Configuration - Force encryption set ON?
From Technet at http://support.microsoft.com/kb/318605
If the Force Protocol Encryption option is turned on on the server by using the Server Network Utility, communication between all clients and SQL Server is encrypted....
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
Viewing 15 posts - 18,556 through 18,570 (of 19,560 total)