Viewing 15 posts - 18,916 through 18,930 (of 19,560 total)
Here is a pretty good read on it.
http://codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspx
In the comments section there is a series of comments by Dave Naples covering User Information Retrieval. In that section he covers...
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 4, 2009 at 5:22 pm
Yes. Sometimes the connection managers may be a bit finicky so you may need to try a few of them.
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 4, 2009 at 5:03 pm
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
December 4, 2009 at 4:24 pm
You mean I can't run SQL Server on Knoppix and fail replication over to the subscriber on an as-needed basis?:-P:-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 4, 2009 at 4:14 pm
Lynn Pettis (12/4/2009)
When a CTE is used in a statement that is part of a batch, the statement...
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 4, 2009 at 12:26 pm
siddaiah.k (12/4/2009)
yes , I am preparing for interview for ssrs position .plz send ssrs interview questions and answers or send links
Where are you interviewing?
As for the link provided, If you...
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 4, 2009 at 12:21 pm
use the sp_help_revlogin script - execute from the Master database.
You need to execute it from the 2000 server, copy the results to the 2005 server and then execute that.
To verify...
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 4, 2009 at 12:14 pm
For semantics, code in previous post would be:
;
WITH dedupeCTE (ID, DuplicateCount)
AS
(
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 4, 2009 at 12:09 pm
cos_ta393 (12/4/2009)
Jason,Thanks for your assistance. I get an error message as below:
WITH dedupeCTE (ID, COUNT(*) AS DuplicateCount)
AS
(
...
)
...
Change your cte declaration just a little
WITH dedupeCTE (ID, DuplicateCount)
AS
(
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 4, 2009 at 12:07 pm
bitbucket-25253 (12/4/2009)
Hate to be picky but if the ; is at the end of the last T-SQL code line (not a comment line) before the WITH, then doesn'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
December 4, 2009 at 12:05 pm
Bob Hovious 24601 (12/4/2009)
This isn't the right thread for technical questions. I'd move it to one of the usual forums.
No.... that's just what they'll be expecting us to do..... :smooooth:
Glad...
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 4, 2009 at 11:45 am
GSquared (12/4/2009)
Bob Hovious 24601 (12/4/2009)
Visions of William Shatner in Airplane II: The Sequel.
I thought it was Lloyd Bridges.
Bru: Lynn is correct.
If I post something that...
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 4, 2009 at 11:44 am
In addition to the already listed options, try some freelance work. If you can get some freelance work under your belt you could add that to your resume.
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 4, 2009 at 11:33 am
Ratfink
Disappointment
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 4, 2009 at 9:03 am
Best of Luck Gus. Same sentiment as the others - sounds like a sinking ship to me.
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 4, 2009 at 9:02 am
Viewing 15 posts - 18,916 through 18,930 (of 19,560 total)