Viewing 15 posts - 12,901 through 12,915 (of 19,560 total)
squid
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
August 12, 2010 at 9:58 am
Re-run this query and post back the results:
USE [msdb]
SELECT object_name(i.object_id) as objectName,
i.[name] as indexName,
sum(a.total_pages) as totalPages,
sum(a.used_pages) as usedPages,
sum(a.data_pages) as dataPages,
(sum(a.total_pages) * 8) / 1024 as totalSpaceMB,
(sum(a.used_pages) * 8) / 1024...
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
August 12, 2010 at 9:57 am
Alvin Ramard (8/12/2010)
CirquedeSQLeil (8/12/2010)
In case any of you threadizens are available or interestedGrant will be presenting to my UG tonight. You can start joining the livemeeting at 6PM PST.
I'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
August 12, 2010 at 9:51 am
Lookup DBCC Shrinkfile. I believe you will have greater success with that.
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
August 12, 2010 at 9:49 am
In case any of you threadizens are available or interested
Grant will be presenting to my UG tonight. You can start joining the livemeeting at 6PM PST.
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
August 12, 2010 at 8:44 am
David Benoit (8/11/2010)
Steve Jones - Editor (8/11/2010)
One a side note, I thought this...
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
August 11, 2010 at 3:43 pm
LutzM (8/11/2010)
you asked for some improvement ideas for the SSC site: add the option to upload (and play) sound files :-D:-D
Then we could actually hear the pronounciation of all...
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
August 11, 2010 at 2:53 pm
Either this has been resolved or is not a pressing issue.
An update from the OP would be nice.
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
August 11, 2010 at 2:06 pm
i recommend you use the dbcc shrinkfile.
Script it out in a script window and you will probably have greater success.
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
August 11, 2010 at 12:41 pm
What is the process you are using to try and shrink the files?
through the gui, via script?
If script are you using dbcc shrinkdb or shrinkfile?
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
August 11, 2010 at 12:35 pm
jcrawf02 (8/11/2010)
Grant Fritchey (8/11/2010)
How about Worcester?If you read German & English the correct pronunciation is, of course:
Vorchester
If you're from Massachusetts though, you'd say:
Woostah
Figure that one out.
Hmm, there's a Wooster Ohio,...
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
August 11, 2010 at 12:19 pm
GilaMonster (8/11/2010)
CirquedeSQLeil (8/11/2010)
One I like from South Africa is Hluhluwe. And yes I had no clue the first time I saw it.
Yeah, that one is hilarious. I'll give...
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
August 11, 2010 at 12:16 pm
Ray K (8/11/2010)
CirquedeSQLeil (8/11/2010)
Ray K (8/11/2010)
http://www.sqlservercentral.com/Forums/Topic967585-392-2.aspx#bm967672
What part of "I figured out my problem" does he NOT understand?!?!?!? :angry:
Granted, I don't...
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
August 11, 2010 at 12:12 pm
Another alternative to that report is to re-run the last query that you ran showing the values for the sysxmit... table.
Run that query and post back the values returned for...
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
August 11, 2010 at 11:56 am
Ray K (8/11/2010)
http://www.sqlservercentral.com/Forums/Topic967585-392-2.aspx#bm967672
What part of "I figured out my problem" does he NOT understand?!?!?!? :angry:
Granted, I don't know as much...
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
August 11, 2010 at 11:55 am
Viewing 15 posts - 12,901 through 12,915 (of 19,560 total)