Viewing 15 posts - 38,971 through 38,985 (of 49,552 total)
For some info on scalar functions, including the difficulting in seeing how they perform
http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 8:35 am
Oh yay. 🙁
Another email accusing me of personal attacks and damaging someone's public image by 'misleading' people about his statements.
Sometimes I wonder why I bother.....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 8:24 am
Threads can't be deleted.
No replies here please. Direct replies to http://www.sqlservercentral.com/Forums/Topic721366-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 8:19 am
It's the data and log file for TempDB. That's the DB where temp tables and table variables are stored and where SQL stored intermediate results for queries (spools, hashs, etc)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 8:18 am
The only way you're going to see the passwords is if you put a network sniffer in place and are using unencrypted communication. SQL will not allow you to see...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 7:51 am
Now that's taking white space insensitive just a little too far.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 7:49 am
Are you running this on your production server or on a dev server? (hint, you should not ever run index tuning wizard or database tuning adviser on a production system)
Does...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 7:48 am
guptaajay1985 (5/21/2009)
I am using ss2k ...
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 7:44 am
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=454744
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 3:57 am
Ian Scarlett (5/21/2009)
Why it doesn't work with a datetime2 must be down to the underlying datatypes Microsoft are using internally.
Datetime is internally a float and can implicitly convert to and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 3:50 am
SA is sysadmin and has all permissions on the server anyway. There's no need to assign it anything.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 3:46 am
That's not built-in SQL error. The error number (50000) indicates that it's being raised in that procedure. Take a look through that proc for code like this, and see...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 3:46 am
Tom Brown (5/21/2009)
You mean you don't count those headless voles, rat livers and mouse innards as wages.
Mine never bring me anything. Only once they brought a bird in and then...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 3:38 am
sk.panda (5/21/2009)
Should the above command is the appropriate solution for Execution paln?
What are you trying to do? If you just want to see the query's exec plan, run it in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 12:21 am
Jan Van der Eecken (5/20/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2009 at 12:13 am
Viewing 15 posts - 38,971 through 38,985 (of 49,552 total)