Viewing 15 posts - 5,626 through 5,640 (of 19,560 total)
GilaMonster (9/14/2012)
Lynn Pettis (9/14/2012)
Nothing like having two people obviously in over their heads this week.Which 2 are you thinking about?
Installing SQL 2012, dropping filegroups? Or are there more?
Speaking of Mr....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 14, 2012 at 1:59 pm
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved me...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 14, 2012 at 1:58 pm
Cliff Jones (9/14/2012)
capnhector (9/14/2012)
Ray K (9/14/2012)
Supertramp(what I'm listening to right now)
super freak
Super man
super ex girlfriend
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 14, 2012 at 9:08 am
Run the following:
SELECT name,physical_name
FROM sys.master_files
WHERE DB_NAME(database_id) = 'deedroom'
I want to see what the catalog views have to say about this issue on the instance you are seeing this issue.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 13, 2012 at 8:43 pm
That seems to be the case. Maybe we recommend hiring a consultant?:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 13, 2012 at 4:44 pm
Run the query I posted earlier and post the results please.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 13, 2012 at 4:38 pm
stanlyn (9/13/2012)
From that article, did you read the very last part as show here:
It is quite simple to fix this error, but you will need to delete all the Metadata...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 13, 2012 at 4:17 pm
GilaMonster (9/13/2012)
Anyone feel up to helping here?: http://www.sqlservercentral.com/Forums/Topic1358758-391-1.aspx
We'll see. I hope I can be of help.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 13, 2012 at 4:14 pm
Run the following to determine if image type data (LOB) is in those filegroups. Post all results please
Select FileGroupName = filegroup_name(a.data_space_id)
,TableName = object_name(p.object_id)
,IndexName = i.name
,LOBUsedPages = a.used_pages
,LOBTotalPages = a.total_pages
,LOBDataSizeMB...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 13, 2012 at 4:13 pm
stanlyn (9/13/2012)
Running your script returns no records and I see no way of identifying what else is there. I DID explicitly deleted all indexes first before deleting the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 13, 2012 at 4:10 pm
Good question
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 13, 2012 at 4:55 am
This would be really great. I have 10, wait 15, wait 20 of those things it seems to be piling up right now. All of these special projects...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 12, 2012 at 8:59 pm
jasona.work (9/12/2012)
SQLRNNR (9/12/2012)
premeditatedPrecrime
minority
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 12, 2012 at 8:55 pm
sudhirnune (9/12/2012)
Yes it running Perfectly in all the places....! But Fails on one Server. that to when the File size is greater than 2 MB
Running perfectly in all the places??
Is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 12, 2012 at 8:37 pm
premeditated
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 12, 2012 at 5:31 pm
Viewing 15 posts - 5,626 through 5,640 (of 19,560 total)