Viewing 15 posts - 15,436 through 15,450 (of 19,560 total)
lmu92 (4/2/2010)
Something like this:
DECLARE @tbl TABLE
(
CustNumber INT, FirstName VARCHAR(30), LastName VARCHAR(30), City VARCHAR(30)
)
INSERT INTO @tbl
SELECT 345321 ,'John','Doe','Kellogg' UNION ALL
SELECT...
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
April 2, 2010 at 3:39 pm
WayneS (4/2/2010)
Paul White NZ (4/2/2010)
Steve Jones - Editor (4/2/2010)
Paul White NZ (4/2/2010)
Yay! My apply articles have been scheduled!!! 12th & 19th April - excited :w00t:Thanks Steve!
You are very...
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
April 2, 2010 at 3:36 pm
Pranav Shah-410191 (4/2/2010)
Thanks for the response, I have never used multiple databases in this scenario, not 100. I am coming from Oracle experience for the last few...
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
April 2, 2010 at 3:34 pm
Paul White NZ (4/2/2010)
Trey Staker (4/2/2010)
Answering the question a day late with the answer published in the news letter?Is it? Oh, well that might explain it too, then!
Answering 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
April 2, 2010 at 3:27 pm
Steve,
Will you take a look at http://www.sqlservercentral.com/Forums/Topic896017-433-1.aspx
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
April 2, 2010 at 3:24 pm
Paul White NZ (4/2/2010)
CirquedeSQLeil (4/2/2010)
I sit here and wonder how those people at the top are nearly perfect in the QOD with so many that were wrong.Multiple registrations?
Probably - just...
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
April 2, 2010 at 3:21 pm
Thanks Steve
Happy Easter to you and enjoy the weekend.
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
April 2, 2010 at 2:21 pm
Nice article Ian. Thanks.
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
April 2, 2010 at 2:19 pm
Knowing that a majority are MS employees may have a little to do with it. With some of the nonMS people attending, I am surprised that the pass rate...
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
April 2, 2010 at 2:06 pm
I would look for some long running transactions or other jobs.
An alternative could be related to a heavily fragmented file system (unrelated to indexes or database fragmentation).
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
April 2, 2010 at 1:40 pm
To reiterate what Ron has said, please remove the double quotes, and format the code using the code link.
Even though the double quotes will work around column alias' like 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
April 2, 2010 at 1:37 pm
CirquedeSQLeil (4/2/2010)
Steve Jones - Editor (4/2/2010)
The QOD isn't appropriate. It's more for the junior people that are trying...
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
April 2, 2010 at 1:23 pm
Lynn Pettis (4/2/2010)
Paul White NZ (4/2/2010)
Lynn Pettis (4/2/2010)
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
April 2, 2010 at 1:20 pm
It looks like the xp_readerrorlog is different in 2005 than in 2000. This is where you are getting the error message. You may need to add some fields...
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
April 2, 2010 at 1:16 pm
Steve Jones - Editor (4/2/2010)
The QOD isn't appropriate. It's more for the junior people that are trying to...
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
April 2, 2010 at 1:06 pm
Viewing 15 posts - 15,436 through 15,450 (of 19,560 total)