Viewing 15 posts - 256 through 270 (of 489 total)
You rproblem is in this section of the code
sudhakara (2/27/2011)CROSS APPLY sys.dm_exec_sql_text(sql_handle)
To use the dm_exec_sql_text function you need VIEW SERVER STATE permissions. See http://msdn.microsoft.com/en-us/library/ms181929.aspx?ppud=4
You can fix it by making the...
February 27, 2011 at 2:35 pm
TheSQLGuru (2/25/2011)
For a small number of rows you won't see any signifiacnt performance diference,
That is absolutely not true in all cases.
You're correct, my statment isn't true in all...
February 27, 2011 at 1:22 pm
For a small number of rows you won't see any signifiacnt performance diference, but as the rowcount goes up you will find temp (#) tables perform better than table variables...
February 24, 2011 at 1:11 pm
I've followed up on this and it looks like this is a bug in SQL 2008 R1 and R2.
I'd be interested to know if anyone has checked their 2008 SSRS...
February 21, 2011 at 3:01 pm
sandhyarao49 (4/28/2010)
To my Knowledge and...
February 20, 2011 at 1:31 pm
GP-395290 (3/18/2008)
Hello,Quick question about ALLOW_PAGE_LOCKS. Should I set this to ON for all indexes in a heavy transaction based system?
To extend my earlier post, the default setting is ON. I...
February 16, 2011 at 6:42 pm
GP-395290 (3/20/2008)
February 16, 2011 at 6:33 pm
Sounds like a round about way to do this. You could just create a small test database on the new drives. If it works SQL can see it and you...
February 16, 2011 at 2:50 pm
Thanks all for the replies. None of the documentation is really that explicit. I've worked out that you can set this up and for each SQL Instance on the cluster...
February 15, 2011 at 6:29 pm
David Benoit (2/14/2011)
One question too; how are they determining that tempdb needs to be put on local drives? Why not properly configure a SAN presentation to support the activity?
They had...
February 14, 2011 at 1:35 pm
Henry Treftz (2/11/2011)
February 13, 2011 at 2:35 pm
On of the event recorded in the default trace is the Data File auto grow event (trace_event_id = 92). So without all the complex sluthing you can look here and...
January 27, 2011 at 3:43 pm
Yes it can be done, but it's risky and this is not really the place to do loops like this. I would advise you build this sort of process into...
January 27, 2011 at 3:26 pm
After changing the password, write it down and put it in a safe or save it in an electronic password safe. Then don't use it except for emmergencies. In 17...
January 27, 2011 at 12:26 pm
It would be good if you posted the error message when the restore fails. Also look in the logs and see what happened 3 weeks ago when it started failing.
In...
January 27, 2011 at 12:21 pm
Viewing 15 posts - 256 through 270 (of 489 total)