Forum Replies Created
Viewing 15 posts - 9,166 through 9,180 (of 19,560 total)
-
RE: blocked-process-report help
How do you have FKs defined on these tables?
DELETE FROM [FormWorks_UncollatedPage] WITH (ROWLOCK) WHERE [ItemId]=@ItemID;
DELETE FROM [FormWorks_Page] WITH (ROWLOCK) WHERE [ItemId]=@ItemID;
DELETE FROM [FormWorks_Document] WITH (ROWLOCK) WHERE [ItemId] =...
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 -
RE: How to Become MVP?
Tom.Thomson (8/8/2011)
Lynn Pettis (8/8/2011)
@SQLFRNDZ (8/8/2011)
I understood Lynn, that I did not mention any where that I want to become MVP.Actually, you did:
@SQLFRNDZ (8/5/2011)
...Thanks Kraig and I will be an...
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 -
RE: The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online
chris.caines (8/6/2011)
Interesting fact and partially related to your second suggestion, if I detach, copy and reattach the database to a different SQL server, I can back it up fine. So,...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 -
RE: Today's Random Word!
Tom.Thomson (8/5/2011)
mtillman-921105 (8/5/2011)
Tom.Thomson (8/5/2011)
Revenant (8/5/2011)
bopeavy (8/5/2011)
crookj (8/5/2011)
bopeavy (8/5/2011)
--------------------------------------------------------------------------------
WEEKEND!
At Bernie's ------ Darn, here we go again....
Party ------Yep Pee!
Beers!
Wines!!
Song
Women!!!
Why are the last two 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 -
RE: blocked-process-report help
What generated this report?
It looks like whatever process it is, truncated the inputbuffer node of the blockedprocess node. You can see that the Select statement got cut off.
I'd recommend...
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 -
RE: SQL server vs Access in the job market
Also consider that most DBAs do not consider Access as a Database. It is something more typically used by business persons to achieve a short term goal without long-term...
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 -
RE: How to Become MVP?
@SQLFRNDZ (8/5/2011)
Craig Farrell (8/5/2011)
@SQLFRNDZ (8/5/2011)
Thank you for the information.I was just posted this topic because I see this MVP tag on most sites and blogs of experts and...
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 -
RE: foreign keys
Better option would be to load data into the parent tables first and ensure that you won't get an FK violation error when loading the child tables.
That said - either...
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 -
RE: test vouchers with free 2nd shot
Not currently available but you can check the Microsoft Learning site for these promotions.
http://www.microsoft.com/learning/en/us/special-offers.aspx#tab1
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 -
RE: Are the posted questions getting worse?
GilaMonster (8/5/2011)
It was hit "I see that on expert's blogs. Why shouldn't I have it?" that got me.I loved your post about "are you in the top 250" after laying...
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 -
RE: Are the posted questions getting worse?
GilaMonster (8/5/2011)
SQLRNNR (8/5/2011)
GilaMonster (8/5/2011)
Anyone want to 'help' out here? http://www.sqlservercentral.com/Forums/Topic1155386-391-1.aspxp.s. if you go to his blog, several posts have pieces copy-paste from a Microsoft webpage, no attribution
Yeah - I actually...
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 -
RE: Are the posted questions getting worse?
And your edit came in after I hit quote - 😀
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 -
RE: Are the posted questions getting worse?
GilaMonster (8/5/2011)
SQLRNNR (8/5/2011)
GilaMonster (8/5/2011)
Anyone want to 'help' out here? http://www.sqlservercentral.com/Forums/Topic1155386-391-1.aspxp.s. if you go to his blog, several posts have pieces copy-paste from a Microsoft webpage, no attribution
Yeah - I actually...
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 -
RE: Are the posted questions getting worse?
GilaMonster (8/5/2011)
Anyone want to 'help' out here? http://www.sqlservercentral.com/Forums/Topic1155386-391-1.aspxp.s. if you go to his blog, several posts have pieces copy-paste from a Microsoft webpage, no attribution
Yeah - I actually recently wrote...
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 -
RE: Are the posted questions getting worse?
Craig Farrell (8/5/2011)
WayneS (8/5/2011)
Craig Farrell (8/5/2011)
A moment of Friday Humor...Time to optimize, perhaps?
You know, for a not-so-small amount, I can do things like optimize queries. 😉
LOL, don't think I didn't...
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
Viewing 15 posts - 9,166 through 9,180 (of 19,560 total)