Viewing 15 posts - 16,876 through 16,890 (of 19,560 total)
I have a bunch of certifications. Nothing since MCDBA 2000. I did a lot of cert testing early on due to working in environments where it was a...
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 3, 2010 at 6:27 pm
vbprogrammer1986 (3/3/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 3, 2010 at 6:14 pm
gmamata7 (3/3/2010)
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5d33cdc5-998c-4b11-8b8a-372d6abca723?prof=requiredI went through the above link which addresses this issue. Is having blocking with reportservertempdb normal?
please advice
Blocking would not be normal. As described in that link you found,...
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 3, 2010 at 6:07 pm
SQL 2005
Select s.name +'.'+ o.name as TableName,o2.name as FKName,c.name as FKColumn
From sys.foreign_key_columns fk
Inner Join sys.objects o
On o.object_id = fk.parent_object_id
Inner Join sys.schemas s
On s.schema_id = o.schema_id
Inner Join sys.objects o2
On o2.object_id =...
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 3, 2010 at 5:57 pm
ALIF-662928 (3/3/2010)
Hi,Does any one have a script to ENABLE and DISABLE all the Indexes for all the Tables of a particular database on sql server 2005.
To disable
select 'alter index '...
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 3, 2010 at 5:33 pm
janiet (3/3/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 3, 2010 at 5:22 pm
Check out this article for some tips
http://msdn.microsoft.com/en-us/library/cc966412.aspx
Each environment will be different. You should test your system, baseline it, and then trend it over 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 3, 2010 at 5:18 pm
Classic "It Depends" dilemma. I sit the fence on this one because there are scenarios where one is obviously better than the other, and vise-versa - for the customer....
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 3, 2010 at 5:13 pm
Steve is correct about the browser, port and using an FQDN makes sense.
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 3, 2010 at 5:03 pm
The below article has a series of Q and A on the topic.
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 3, 2010 at 4:53 pm
antony-688446 (3/3/2010)
...If this was on a MS or Sun exam, the answer would be error...
I have seen Microsoft questions with just as much detail as this. Assumptions still had...
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 3, 2010 at 3:59 pm
Tim,
Some of us believe you did a fine job on your first article. I agree with Steve, Karen, and ThisisFutile. Don't let the high-brows beat you down over...
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 3, 2010 at 2:58 pm
tstaker (3/3/2010)
http://www.sqlservercentral.com/Forums/Topic874846-2631-1.aspx
I admire those of you who put yourselves out there to write the articles and really...
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 3, 2010 at 2:52 pm
Lynn Pettis (3/3/2010)
sore, as in still after working 9 soccer games this past weekend.
showing your age a bit there Lynn
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 3, 2010 at 2:47 pm
fibula
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 3, 2010 at 2:28 pm
Viewing 15 posts - 16,876 through 16,890 (of 19,560 total)