Viewing 15 posts - 16,651 through 16,665 (of 19,560 total)
Joy Smith San (3/10/2010)
Ok.. I got it wrongly. You are right too..Still I would like to goto other places n work.
Lemme see if I can catch something.
Fair enough.
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
March 10, 2010 at 12:19 pm
GTR (3/9/2010)
Jason,Are you sure DBCC shrinkfile will shrink below initial size of the mdf or ldf file size?
Yes, I have done it hundreds of times. I use it to...
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
March 10, 2010 at 12:12 pm
YSLGuru (3/10/2010)
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
March 10, 2010 at 11:04 am
Steve Jones - Editor (3/10/2010)
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
March 10, 2010 at 10:45 am
perturbed (@ idiot family members)
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
March 10, 2010 at 10:30 am
Chris Morris-439714 (3/10/2010)
CirquedeSQLeil (3/9/2010)
I guess that psychic helmet I bought is working correctly then. 😀Beedeebeedeebeedee
I guess I spelled it wrong - is it Twiggy or Twiki?
Aha, I think you mean...
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
March 10, 2010 at 10:27 am
sanketahir1985 (3/10/2010)
-- Create the temp table for further querying
CREATE TABLE #temp(
rec_idint IDENTITY (1, 1),
table_namevarchar(128),
nbr_of_rowsint,
data_space_KBdecimal(15,2),
index_space_KBdecimal(15,2),
total_size_KBdecimal(15,2),
percent_of_dbdecimal(15,12),
db_sizedecimal(15,2))
-- Get all tables, names, and sizes
EXEC sp_msforeachtable @command1="insert into #temp(nbr_of_rows, data_space_KB,index_space_KB) exec sp_mstablespace...
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
March 10, 2010 at 9:33 am
Kimberly L. Tripp (3/10/2010)
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
March 10, 2010 at 9:29 am
sameerchachad 69959 (3/9/2010)
So, when you are saying that IF a Clustered Index already exists, then your what you are mentioning is valid. Else the Primary key, which is usually created...
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
March 10, 2010 at 9:23 am
tstaker (3/10/2010)
Paul White (3/10/2010)
When I get my next data warehouse, I'm gonna carpet it :w00t:Mmm, nice warm floors...
Lol. I saw that thread.
Ha nice pun. See, 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
March 10, 2010 at 9:16 am
Paul White (3/10/2010)
When I get my next data warehouse, I'm gonna carpet it :w00t:Mmm, nice warm floors...
Floors - wouldn't it be rack?:-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
March 10, 2010 at 9:13 am
Lynn Pettis (3/10/2010)
Paul White (3/10/2010)
Lynn Pettis (3/10/2010)
Actually, I'd carpet the office area in the warehouse, just not the warehouse area itself.
C'mon guys, think outside of the box! Ok, so...
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
March 10, 2010 at 9:11 am
My preference has always been to use dbcc shrinkfile in SQL 2005. This allows one to shrink below the initial database size. This could also be a time...
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
March 9, 2010 at 10:02 pm
curse the double post...
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
March 9, 2010 at 9:46 pm
Nice question. Keep 'em coming.
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
March 9, 2010 at 9:46 pm
Viewing 15 posts - 16,651 through 16,665 (of 19,560 total)