Viewing 15 posts - 48,136 through 48,150 (of 49,552 total)
karthikeyan (11/27/2007)
Gila,I am not ordering you,Just my kind suggestion.Thats it.Because i am using sql2000,so if you give some generic query then i will try it out.
If you want a SQL...
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
December 2, 2007 at 11:36 pm
Nice. I'm also a little tired of people looking for a free lunch.
Problem is, those who need it most will likely not be the people who read it.
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
November 27, 2007 at 2:38 am
SET NOEXEC ON
Run the query.
With noexec on, all SQL will do is parse and compile the query. If it encounters syntax errors, you'll get the error back.
I could be mistaken,...
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
November 27, 2007 at 2:27 am
Thanks. Will let you know afterwards how it went. I'm not looking forward to it, since admin's not my main job function.
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
November 27, 2007 at 1:37 am
In your case, probably because the column is not nullable, or because there's an index on that column and SQL's decided that it's the best way to do the counts.
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
November 27, 2007 at 1:28 am
If you've never done a full database backup since switching to full recovery mode, the log will auto-truncate as if it was in simple recovery mode.
Fairly simple reason. Without a...
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
November 26, 2007 at 2:09 pm
When SQL gets restarted? None of the caches are persisted to disk so all are empty when SQL starts up.
I wouldn't recommend doing either on a production server, certainly not...
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
November 26, 2007 at 2:00 pm
Ha! Found it. That had me stumped for some minutes.
You're missing an END. There's a BEGIN on line 7, but no matching end. Put the END after the last EXEC...
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
November 26, 2007 at 1:59 pm
Very strange. Also getting syntax errors when I get management studio to do a syntax check.
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
November 26, 2007 at 1:56 pm
Jeff Moden (11/26/2007)
The "how long" and "who's going to be using this and how" actually doesn't matter much.
I had a reason for writing those, but now I can't...
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
November 26, 2007 at 1:38 pm
It's always recommended to update the stats on all tables after an upgrade to SQL 2005.
2005 keeps more detailed column stats and while the optimiser can use the SQL...
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
November 26, 2007 at 1:37 pm
webrunner (11/14/2007)
1. If I turn off Auto Shrink where I see it on - and I have already found a few cases - do I also need to add a...
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
November 26, 2007 at 1:24 pm
h.schlais (11/26/2007)
cast(Bal_No as integer) as Bal_No ...
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
November 26, 2007 at 1:19 pm
Eduardo Olivera (11/26/2007)
We are currently in the planning stages of a comprehensive set of tests that would allow us to determine which indexes are no longer, or never...
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
November 26, 2007 at 8:31 am
n 2005, you can see which queries are in the plan cache, along with the time the plan was put into the cache and the last time it was executed....
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
November 26, 2007 at 8:21 am
Viewing 15 posts - 48,136 through 48,150 (of 49,552 total)