Viewing 15 posts - 14,431 through 14,445 (of 49,552 total)
Not unless you're using one of the snapshot isolation levels or have complex select/from portions to those insert/updates that does hash joins or needs work tables or have triggers on...
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
February 5, 2013 at 4:22 am
Under the server folder you see logins and the only permissions they have are server-wide permissions (sysadmin, security operator, backup operator, etc)
Under the database folder you see database users 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
February 5, 2013 at 4:09 am
Can you post the execution plan 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
February 5, 2013 at 4:02 am
Why would you run them on an undamaged database to 'test'? Seeing as the command is intended repair damage, running on an undamaged database is not going to test anything.
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
February 5, 2013 at 3:53 am
sumith1andonly1 (2/5/2013)
what will be the maximum value of Statistics Logins/sec?
Theoretical maximum, not sure if there is one. Actual maximum that you get, you'll have to monitor over a period of...
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
February 5, 2013 at 3:29 am
Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.
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
February 5, 2013 at 3:07 am
Mike Seattle (2/5/2013)
I think changes to the OVER clause are pretty useful.
What about them are useful? What problems can you solve now that you couldn't solve before?
I asked this question...
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
February 5, 2013 at 3:04 am
Why did you run that on the database WFilter when it's MSDB that's damaged?
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
February 5, 2013 at 2:42 am
Errr... what don't you understand?
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
February 4, 2013 at 2:28 pm
http://support.microsoft.com/kb/956893/en-us
Virtualization Snapshots for Hyper-V or for any virtualization vendor are not supported to use with SQL Server in a virtual machine. It is possible that you may not encounter any...
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
February 4, 2013 at 8:53 am
greg.senne (2/4/2013)
GilaMonster (2/4/2013)
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
February 4, 2013 at 8:14 am
greg.senne (2/4/2013)
Okay, but I don't know how to use the output keyword to output more than one row.
The output keyword will output as many rows as the operation affected....
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
February 4, 2013 at 8:06 am
Grant Fritchey (2/4/2013)
And to directly answer your question, at least a little, check out the Extended Events gui. That's pretty slick.
I could live without the GUI, the enhanced windowing functions...
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
February 4, 2013 at 8:00 am
Output into a table variable, then work from there
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
February 4, 2013 at 7:05 am
Mike Seattle (2/4/2013)
If they ask me about 2012, I want to at least tell them I have investigated the new features.
Have you investigated the new features? What are your...
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
February 4, 2013 at 6:34 am
Viewing 15 posts - 14,431 through 14,445 (of 49,552 total)