Viewing 15 posts - 16 through 30 (of 191 total)
Thanks Grant, Any particular script do you suggest for compilation/recompilation trouble shoot?
December 19, 2018 at 10:04 am
@phil, just play with AdventureWorks database.
December 19, 2018 at 10:02 am
Thanks for your reply, but since above query has 'group by' not able to add any other columns!
December 19, 2018 at 9:56 am
Thanks goher2000 and Sue_H for taking your time to reply my question. One more thing, what if the 'Cntr_Value' was 300GB? What actions could be taken to make Buffer pool...
October 4, 2018 at 8:25 am
It worked!!! Hat's off to you Sue. Thanks you so much for your kind reply.
June 19, 2018 at 1:52 pm
First of all thanks for your reply. Secondly, sorry, English my second language. Is 'bothering' sounds better? (Don't get me wrong, I like when people point my 'weakness' because that...
June 19, 2018 at 1:26 pm
thanks goher2000 for your response.
Just wanted to clear my requirement, I...
February 14, 2018 at 12:12 pm
SQLServer Alert System: 'ProdDatabase Percent LogUsed 80%' occurred on \\ProdserverAZ
January 5, 2017 at 10:52 am
Thanks millions Eric and Grant.
November 18, 2016 at 1:18 pm
if you do RDP to the server and right click on SSMS logo it gives your an option as 'run as different user" but it doesn't work on client
November 18, 2016 at 12:43 pm
Thanks Eric and SQL Guru.
Eric, so you think I can run "sys.dm_db_index_usage_stats" and find if there are index scan taking place?
or any other step should I take?
or this...
August 24, 2016 at 12:19 pm
Thanks Steve for your quick reply but I am getting this:
Msg 137, Level 15, State 2, Line 2
Must declare the scalar variable "@id".
August 11, 2016 at 9:05 am
hi Lowell,
Thanks for the script. Just need help to filter on the columns"
Only columns I wants are:
Date
Object Name
DatabaseName
Starttime
ServerName
User_name
ApplicationName
DDL operation
Can you please post updated script?
May 24, 2016 at 12:20 pm
Viewing 15 posts - 16 through 30 (of 191 total)