Viewing 15 posts - 14,281 through 14,295 (of 19,560 total)
You're welcome.
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 4, 2010 at 4:16 pm
Mani-584606 (5/4/2010)
Query1:
use tempdb
go
SELECT OBJECT_NAME(id), rowcnt
FROM tempdb..sysindexes
WHERE OBJECT_NAME(id) LIKE '#%'
ORDER BY rowcnt DESC
Results:
328 row(s) affected)
#5629CD9C0
#58DCE86C0
#59511E610
#5A45429A0
#5BB955170
#5BB955170
#Temp_______________________________________________________________________________________________________________0000000046480
#Temp_______________________________________________________________________________________________________________0000000046480
#5CECA51B0
#5DE0C9540
#5E15D37E0
#5E95C1C20
Query2:
DBCC OPENTRAN('tempdb')
Results:
No...
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 4, 2010 at 4:15 pm
Trey Staker (5/4/2010)
Collimation:From the guide of my new Meade binoculars -- 92618, "Its precision optics can become misalligned (out of collimation) as a result of rough tratment..."
or is that tratmentitation?
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 4, 2010 at 3:24 pm
Interesting solution.
Thanks for the article.
I also like the additional points of Interest that Paul has raised. They bring a good amount of education as well.
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 4, 2010 at 2:58 pm
You are welcome.
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 4, 2010 at 2:18 pm
And not some lame short blog post - must be article worthy!!
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 4, 2010 at 2:10 pm
jcrawf02 (5/4/2010)
It's just the number of random words that determines which thread is used.Kind of like Twitter vs blogging...
[ducks/]
I would like somebody do an entire blog post via twitter:-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
May 4, 2010 at 2:09 pm
Brandie Tarvin (5/4/2010)
wodom (5/4/2010)
Brandie Tarvin (5/4/2010)
He's asking if your SQL 2000 is 64 bit or 32 bit.
I don't know. Haven't been able to find out. We're supposed to download 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 4, 2010 at 1:44 pm
Or for 2005, try this:
SELECT [Spid] = session_Id
, [Database] = DB_NAME(sp.dbid)
, [User] = nt_username
, [Individual Query] = SUBSTRING (qt.text,
...
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 4, 2010 at 1:38 pm
Nice program and good luck to all entrants.
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 4, 2010 at 12:32 pm
nelsonj-902869 (5/4/2010)
....I knew those USB sticks would get us in trouble at some time.....oh for a 5Tb stick!!BOFH...that's good...thanks Luke.
A 5Tb stick would be great. Imagine all of 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
May 4, 2010 at 12:30 pm
Steve Jones - Editor (5/4/2010)
I ought to run some numbers on them, but it seems the Random Word has more replies than this thread on some days.
Today being one of...
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 4, 2010 at 11:59 am
I think that helps to prove that things really are not random.
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 4, 2010 at 11:58 am
With the considerations for DR, one must also include considerations for Business Continuity.
200K may seem like a lot of money but it can disappear in a heartbeat with the purchase...
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 4, 2010 at 11:49 am
Grant Fritchey (5/4/2010)
No
Too Late - it's alive!!
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 4, 2010 at 11:43 am
Viewing 15 posts - 14,281 through 14,295 (of 19,560 total)