Viewing 15 posts - 14,326 through 14,340 (of 19,560 total)
Steve Jones - Editor (5/2/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
May 2, 2010 at 11:18 pm
Lynn Pettis (5/2/2010)
On freelancer.com, some one has posted a job looking for an experienced programmer to develop an SQL injection script for godfather points in...
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
May 2, 2010 at 3:23 pm
Yes.
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
May 2, 2010 at 8:00 am
keywestfl9 (5/1/2010)
They want to do for another report in access the same thing,i will try and post it...
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
May 1, 2010 at 11:49 am
Mike Seattle (5/1/2010)
CirquedeSQLeil (4/28/2010)
Change the following line
FROM dbo.TIMEI_DOC_HDR tdh, dbo.TIMEI_DOC_LINE tdlTo use an explicit join.
Could you please explain why? I mean, why is that line causing an error and what...
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
May 1, 2010 at 11:48 am
Steven James Gray (5/1/2010)
Just noticed I'd posted to the SQL 2K forum from your comment. Thats what I get for mis-reading the Active Topics list 😉
It catches all of us...
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
May 1, 2010 at 1:12 am
Michael Valentine Jones (4/30/2010)
This should give you what you are after.Script to analyze table space usage
Nice script.
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 5:13 pm
The difference in size may also be that the sp_spaceused is reporting on clustered indexes where the sp_mstablespace may not be.
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:47 pm
Agreed
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:40 pm
Also try to run an updatestats
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:31 pm
Since that query relies on a MS provided system stored proc and sp_spaceused is a system stored proc, I would venture that some stats are messed up somewhere.
Try this query...
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:30 pm
Lynn Pettis (4/30/2010)
Steve Jones - Editor (4/30/2010)
I think it was OK. From a technical standpoint, it makes sense. The issue seems that some people don't understand log chaining, so things...
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:23 pm
Steven James Gray (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 3:21 pm
Here is a useful article on several different methods to calculate the median.
http://www.simple-talk.com/sql/t-sql-programming/median-workbench/
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:19 pm
MANU-J. (4/30/2010)
whereas sp_spaceused returns index_size of [49928...
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:12 pm
Viewing 15 posts - 14,326 through 14,340 (of 19,560 total)