Viewing 15 posts - 47,686 through 47,700 (of 49,552 total)
Look up the DENSE_Rank funcion in books online. It's a feature new in sQL 2005 and does exactly what you want.
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
January 14, 2008 at 12:12 am
Pleasure
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
January 14, 2008 at 12:04 am
Strange.
Can you try and connect from management studio with that login (without the control server privilidge) and see if you can connect. If not, see exactly what error is given.
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
January 13, 2008 at 11:57 pm
Alan G (1/13/2008)
Is this because the stats facility after the TRUNCATE still thinks there's 2.5m rows 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
January 13, 2008 at 12:07 pm
No sims. Case studies.
Long business case then set of questions based on that business case.
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
January 13, 2008 at 6:42 am
Congrats
441 is a nasty exam. I struggled through it. Make sure you know the work very, very well.
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
January 13, 2008 at 5:31 am
The exact allocation of marks is a secret. No one knows what the percentage is between sims and questions or between the questions themselves. I know (because there's a mention...
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
January 13, 2008 at 5:31 am
I would recommend that you do a stats update after the truncate, as truncate doesn't affect the stats, or the rowmodctr.
If you have auto update stats on, then stats are...
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
January 13, 2008 at 5:27 am
Do the procs do any updates, inserts or deletes?
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
January 12, 2008 at 11:54 am
You could try Paul Randal's blog: http://www.sqlskills.com/blogs/paul/ Might well be something there.
The impression I've got is that 2008 is a very small change, compared to 6.5-7 or 2000-2005
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
January 11, 2008 at 11:27 am
Do you rebuild the index, or reorg 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
January 11, 2008 at 11:25 am
A hypothetical index is created by the database tuning advisor as it's attempting to find the 'correct' indexes. It's dropped once the run is complete
From what I understand, they're indexes...
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
January 11, 2008 at 8:09 am
Control Server = sysadmin. They're the same
What default db is the login set to? Does the login have a mapped user in that db? Is the default db in restricted...
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
January 11, 2008 at 8:05 am
No.
Begin != Begin transaction
Begin...End are just used to group code together. eg
IF (condition)
Begin
Do lots of things
End
Unless you explicitly begin a transaction, SQL works in autocommit,...
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
January 11, 2008 at 7:39 am
Could you post the code please
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
January 11, 2008 at 7:39 am
Viewing 15 posts - 47,686 through 47,700 (of 49,552 total)