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...
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...
February 5, 2013 at 4:09 am
Can you post the execution plan please?
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...
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...
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.
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...
February 5, 2013 at 3:04 am
Why did you run that on the database WFilter when it's MSDB that's damaged?
February 5, 2013 at 2:42 am
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...
February 4, 2013 at 8:53 am
greg.senne (2/4/2013)
GilaMonster (2/4/2013)
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....
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...
February 4, 2013 at 8:00 am
Output into a table variable, then work from there
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...
February 4, 2013 at 6:34 am
Viewing 15 posts - 14,431 through 14,445 (of 49,552 total)