Viewing 15 posts - 10,561 through 10,575 (of 19,560 total)
Never heard of G-Force other than the Disney Guinea Pig movie.
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 6, 2011 at 11:05 am
Stuart Davies (4/6/2011)
eragon
brisingr
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 6, 2011 at 11:00 am
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
April 6, 2011 at 10:55 am
Peter Trast (4/6/2011)
Brandie Tarvin (4/6/2011)
bcsims 90437 (4/6/2011)
sing4you (4/6/2011)
Loch NessNessie the Lock Ness monster
Barney the purple dinosaur
Petie the purple dinosaur slayer ( I have 9 kids, I can't take the music...
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 6, 2011 at 10:54 am
I think then using the synonyms as suggested may be a better option. This would require significant rework up front and promote that synonym through to prod, but then...
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 6, 2011 at 10:48 am
GSquared (4/6/2011)
CirquedeSQLeil (4/6/2011)
GSquared (4/6/2011)
Lynn Pettis (4/6/2011)
Stefan Krzywicki (4/6/2011)
CirquedeSQLeil (4/6/2011)
Roy Ernest (4/6/2011)
GilaMonster (4/6/2011)
Lynn Pettis (4/6/2011)
Star Trek (the Original)My mother loves both that and Thunderbirds.
Gail, Low blow aimed at Lynn... 🙂
I...
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 6, 2011 at 10:43 am
dup post
respond here http://www.sqlservercentral.com/Forums/Topic1089393-1549-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 6, 2011 at 10:37 am
RamSteve (4/6/2011)
Hi! I don't have the Server engine installed on my machine so how would i extract the SSIS package list from batch server ?
Are they all stored in msdb...
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 6, 2011 at 10:25 am
RamSteve (4/6/2011)
I was using the following Script but its not working for SQL 2000 can some one guide...
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 6, 2011 at 10:23 am
Try these
/* SQL 2005 */
SELECT T1.*
FROM dbo.sysdtspackages90 AS T1
INNER JOIN (
SELECT [id], MAX([verbuild]) AS [verbuild]
FROM dbo.sysdtspackages90
GROUP BY [id]) AS T2
ON T1.[id] = T2.[id]
AND T1.[verbuild] = T2.[verbuild]
/*...
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 6, 2011 at 10:15 am
MyDoggieJessie (4/6/2011)
We have a server that executes some rather large queries then pulls the data back 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 6, 2011 at 10:11 am
Mirroring would be less overhead than what you are describing. Also, you may consider clustering. Another consideration to make is that you should work with the network team...
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 6, 2011 at 10:07 am
I prefer to keep the database names the same between environments. One reason is the very reason you are describing. If you develop something in that database 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
April 6, 2011 at 10:04 am
I'm all in favor of continuous education. Continuous testing and monitoring of code being released is a part of that education.
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 6, 2011 at 10:01 am
GSquared (4/6/2011)
Lynn Pettis (4/6/2011)
Stefan Krzywicki (4/6/2011)
CirquedeSQLeil (4/6/2011)
Roy Ernest (4/6/2011)
GilaMonster (4/6/2011)
Lynn Pettis (4/6/2011)
Star Trek (the Original)My mother loves both that and Thunderbirds.
Gail, Low blow aimed at Lynn... 🙂
I remember Star...
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 6, 2011 at 9:53 am
Viewing 15 posts - 10,561 through 10,575 (of 19,560 total)