Viewing 15 posts - 7,666 through 7,680 (of 19,560 total)
It is a deferred transaction.
Check this article for 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
December 2, 2011 at 10:24 pm
Evil Kraig F (12/2/2011)
Ninja's_RGR'us (12/2/2011)
GSquared (12/2/2011)
Ninja's_RGR'us (12/2/2011)
Happy putzy week-end (I hope I got the meaning right!).
Definition 1: unintelligent person: somebody regarded as very unintelligent and unpleasant
But I was just quoting...
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
December 2, 2011 at 11:58 am
junk.jjk (12/2/2011)
Is it possible that the tempDb will now just need to 'hover' at a larger size, and there is nothing really 'wrong' with the sproc?
you need to have 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
December 2, 2011 at 10:46 am
kyle.doouss (11/30/2011)
I would be very glad of any pointers...
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
December 2, 2011 at 10:15 am
So the reason this is occurring is due to the number of records being ported over. The temp table (created in tempdb) is receiving many records and the database...
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
December 2, 2011 at 10:13 am
GSquared (12/2/2011)
SQLRNNR (12/2/2011)
NHibernate ROCKzHEY!! This is supposed to be family-friendly site!
Filter or no filter, there's going too far, and then there's NHibernate!
OHIbernate:-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
December 2, 2011 at 9:32 am
Thanks for the reminder Hugo.
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
December 2, 2011 at 9:09 am
NHibernate ROCKz
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
December 2, 2011 at 9:07 am
We've done a similar thing from time to time. We would detach the database, move the files to a clean volume and then run a defrag utility on 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
December 2, 2011 at 9:00 am
Stefan Krzywicki (12/2/2011)
Steve Jones - SSC Editor (12/2/2011)
Don't be making me add IZ, haz, sertinz and a few more to the "bad words" list here.
There's a "bad words" list? Let...
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
December 2, 2011 at 8:58 am
Which table in this script is your temp table?
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
December 2, 2011 at 8:47 am
To be clear,
Are you asking to execute job1 that is on ServerA from WorkstationB automatically or manually?
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
December 2, 2011 at 8:44 am
Stefan Krzywicki (12/2/2011)
Brandie Tarvin (12/2/2011)
Dev (12/2/2011)
So you guys don’t want to share your jokes with us :crazy:... BTW which language it is?
Haz u nevers herd uf LOLz...
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
December 2, 2011 at 8:40 am
Dhirju (12/2/2011)
i have two server, which is not in domain, they are running in workgroup and in DMZ...
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
December 2, 2011 at 8:34 am
Iz lukz ze nomes Stevie:-D:-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
December 2, 2011 at 8:23 am
Viewing 15 posts - 7,666 through 7,680 (of 19,560 total)