Viewing 15 posts - 16,741 through 16,755 (of 19,560 total)
george sibbald (3/8/2010)
It really frustrates me when people post replies and repeat almost exactly what I said minutes or hours earlier
does anyone else feel 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
March 8, 2010 at 1:17 pm
I suggest creating the maint plan first then. Once the maint plan is done, then I would either create a new SSIS package, or alter your maint plan from...
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 8, 2010 at 1:12 pm
Here's another script. This uses the suggestion by Ron.
Declare @DBNamevarchar(50)
Set @DBName = 'YOURDBNAME'
Select Db_name(ps.database_id) as DBName,object_name(ps.object_id) as TableName,I.name as IndexName
,sum(isnull(ps.avg_record_size_in_bytes,0) * isnull(ps.record_count,0)) as IndexSizeBytes
,sum((isnull(ps.avg_record_size_in_bytes,0) * isnull(ps.record_count,0)) /1024/1024) as IndexSizeMB
From...
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 8, 2010 at 1:07 pm
To create a Backup Plan
To manage the files on disk:
http://www.mssqltips.com/tip.asp?tip=1094
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 8, 2010 at 12:28 pm
ramadesai108 (3/8/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 8, 2010 at 12:23 pm
dbychen (3/8/2010)
"how do you come to 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 8, 2010 at 12:20 pm
dohomebiz (3/8/2010)
DISREGARD
Does that mean you figured it out?
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 8, 2010 at 12:10 pm
dohomebiz (3/8/2010)
select * from detail
and gettign the following error
Major Error 0x80040E37, Minor Error 0
> select * from detail
The specified table does not exist. [...
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 8, 2010 at 12:09 pm
Do you receive any errors?
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 8, 2010 at 12:05 pm
Roy Ernest (3/8/2010)
Of Topic...On an average how many people attend SQLSaturdays?
Good question.
I think this last one hit 1000.
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 8, 2010 at 11:41 am
Steve Jones - Editor (3/8/2010)
I'm noting that if you feel you are impaired, you ought to be responsible enough to tell your boss you can't work.
I think a key...
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 8, 2010 at 11:28 am
The default white background causes too much glare. It is easier for me to look at a black background. For presentations, I stick with the default colors though...
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 8, 2010 at 11:19 am
Jack Corbett (3/8/2010)
WI-DBA (3/8/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 8, 2010 at 11:12 am
GilaMonster (3/8/2010)
And the vague question of the week award goes to....
...
<drum roll>
...
....
http://www.sqlservercentral.com/Forums/Topic878772-1292-1.aspx
Psychic helmet was on for that one. 😀 I like to change my Script Editor colors in SSMS...
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 8, 2010 at 10:58 am
a1011 (3/8/2010)
Go to tools in the menu bar in SSMS...choose options....Expand Environments....Click...
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 8, 2010 at 10:57 am
Viewing 15 posts - 16,741 through 16,755 (of 19,560 total)