Viewing 15 posts - 14,341 through 14,355 (of 19,560 total)
Steve Jones - Editor (4/30/2010)
CirquedeSQLeil (4/30/2010)
Steve,What is this new content of plagiarism? Where can it be found?
??
In reference to your blog. I was curious to find more info...
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
April 30, 2010 at 3:09 pm
Lynn Pettis (4/30/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
April 30, 2010 at 2:59 pm
jcrawf02 (4/30/2010)
Very nice. Must be like voodoo, I feel ill and alien already.
I was hoping to come up with a squeamish color, but this was the closest match I could...
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
April 30, 2010 at 2:51 pm
Good to hear.
It seems appropriate to me (your method for changing the connection).
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
April 30, 2010 at 2:43 pm
jcrawf02 (4/30/2010)
CirquedeSQLeil (4/30/2010)
jcrawf02 (4/30/2010)
:sick::blush::sick::blush::sick::blush::sick::blush::sick::blush::sick:15,000
:alien::rolleyes::alien::rolleyes::alien::rolleyes::alien::rolleyes::alien::rolleyes::alien:
And I was so tempted to do that myself.
I knew you were, but you were being so conscientious about just posting real Threadliness, so figured I'd take...
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
April 30, 2010 at 2:40 pm
To follow up what Grant said, do you have a way you can limit the results to be deleted? Add a range to the query or something that can...
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
April 30, 2010 at 2:14 pm
Try this article.
Look at the tail log section.
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
April 30, 2010 at 2:11 pm
Kenneth Langner Jr. (4/30/2010)
-- Create the temp table for further querying
CREATE TABLE #temp(
rec_idint IDENTITY (1, 1),
table_namevarchar(128),
nbr_of_rowsint,
data_spacedecimal(15,2),
index_spacedecimal(15,2),
total_sizedecimal(15,2),
percent_of_dbdecimal(15,12),
db_sizedecimal(15,2))
-- Get all tables, names,...
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
April 30, 2010 at 2:09 pm
jcrawf02 (4/30/2010)
:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D15,000
:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
And I was so tempted to do that myself.
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
April 30, 2010 at 2:08 pm
I suggest to find what is causing it to be that big. Gianluca proposed a solution. I'll propose another option - read this article[/url] and try it's suggestions
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
April 30, 2010 at 2:07 pm
What is the status of the database?
In Recovery, Offline, Online?
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
April 30, 2010 at 2:03 pm
Then it sounds like the data does not meet the requirements of the query.
Check your data and your query. If the query works on one server but not 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
April 30, 2010 at 1:56 pm
GabyYYZ (4/30/2010)
Lynn Pettis (4/30/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
April 30, 2010 at 1:52 pm
Lynn Pettis (4/30/2010)
Steve Jones - Editor (4/30/2010)
I dfon't think we need licenses for each person. That's why we'd go hosted.Don't fret about $10-20 a month difference. Pick the best service/features.
Sorry,...
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
April 30, 2010 at 1:48 pm
There is a thumbtack icon in the upper right hand corner of the pane. If it is pointed down - the pane is pinned.
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
April 30, 2010 at 1:47 pm
Viewing 15 posts - 14,341 through 14,355 (of 19,560 total)