Viewing 15 posts - 19,081 through 19,095 (of 19,560 total)
Ok - it's not prose or rhyme but it is set to Jingle bells
/*
Pouring through the code
of a cursor based stored proc
Making it set-based
Eating a Pork Chop
Set-based procs we write
Making...
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
November 18, 2009 at 9:50 pm
I don't get the same problem. When that date pops up, it could be due to an invalid date that has been input.
declare @issuedate varchar(8)
Set @issuedate = '20091118'
select Convert(DateTime,...
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
November 18, 2009 at 5:47 pm
That was going to be my next post after he responded with what had been tried already.
Quetzco, as Elliott outlined - it can be done through the use of 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
November 18, 2009 at 5:11 pm
Are these buckets strictly posts or are the QOD points included?
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
November 18, 2009 at 4:29 pm
Colander? - Check
Still unable to understand the brash quips about us Lynn and Bru being rude.
Might have to switch the colander to psychic mode.
Is that Karma Chameleon?
In the meantime, maybe...
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
November 18, 2009 at 3:47 pm
Right there with Bru on this one.
I think I have a grasp of what you want but could be jumping at conclusions that may be wrong without more information.
However, based...
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
November 18, 2009 at 3:20 pm
What have you tried so far?
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
November 18, 2009 at 2:57 pm
VirenMann (11/18/2009)
Can you post some of the questions here?Thanks in advance
viren
SSC is not a Braindump site. Posting any exam questions in braindump format to this site is ill-advised.
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
November 18, 2009 at 2:46 pm
And to reiterate the point...
Applying Service Packs and patches can cause undesirable effects. Thus it is necessary to test the patches in non-production environments before rolling them to production....
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
November 18, 2009 at 2:29 pm
Hmmm. Verified on my default installation that the ServiceName is indeed MSOLAP, and that concurs with the documentation.
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
November 18, 2009 at 1:19 pm
ForumDog and his curses are long gone. Took flight with the rest of the pack - they are somewhere in Minnesota now.
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
November 18, 2009 at 1:06 pm
Do you have adequate permissions in AD to query and pull back the list?
Here is a query that you could integrate into xp_cmdshell if you wanted.
dsquery user -limit 0 |...
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
November 18, 2009 at 12:56 pm
George has a good point. There are scripts available to help automate the index reorgs rebuilds in smaller chunks at a time.
Smaller reindex operations will help to keep 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
November 18, 2009 at 12:49 pm
NP.
One last tidbit. It was written in 2k5. If it needs to work for SQL 2000, you will need to modify as you need.:cool:
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
November 18, 2009 at 12:46 pm
Thanks for the update on what finally worked for you in this scenario.
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
November 18, 2009 at 12:44 pm
Viewing 15 posts - 19,081 through 19,095 (of 19,560 total)