Viewing 15 posts - 9,856 through 9,870 (of 19,560 total)
Oh and one more quick question...
Did you reapply SP2 after installing SSIS?
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
June 6, 2011 at 4:03 pm
Let's start with getting the exact error message.
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
June 6, 2011 at 4:01 pm
Do you mean in functionality or size?
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
June 6, 2011 at 3:56 pm
Nothing more to add to what Gail said. Just following up with support of what she said because it's correct.
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
June 6, 2011 at 3:48 pm
Grant Fritchey (6/6/2011)
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
June 6, 2011 at 3:29 pm
K. I ran both of those queries on SQL 2005, SQL 2008 and 2008 R2 and they work perfectly fine for 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
June 6, 2011 at 1:42 pm
Sorry I do not. The company keeps a tight lid on 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
June 6, 2011 at 1:34 pm
Whenever I look at Grants avatar, I think it is the character from Monsters Inc called Randall Boggs.
http://www.imdb.com/media/rm1156421888/ch0004377
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
June 6, 2011 at 1:33 pm
Alfredo Giotti (6/6/2011)
Hello,Thanks for the information, great to know. Strangely, our internal storage team has not mentioned that EMC is doing away with this module.
Yeah the Legato piece is on...
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
June 6, 2011 at 12:55 pm
We implemented that module and I agree with those assessments. We canned the product and EMC is in the process of canning it too since they have new technology...
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
June 6, 2011 at 12:48 pm
So try this
SELECT sys.columns.is_identity
FROM sys.columns
JOIN sys.objects
ON sys.columns.object_id = sys.objects.object_id
WHERE sys.columns.is_identity = 1 AND
sys.objects.type IN ( N'U' )
AND sys.objects.name = 'Roles'
AND SCHEMA_NAME(schema_id) = 'inter' --added to restrict to specific schemas
It's...
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
June 6, 2011 at 12:32 pm
I have tested both queries on SQL 2008 and both work perfectly fine for me.
Are you getting error messages or is it just that you get no results?
If you are...
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
June 6, 2011 at 12:12 pm
crookj (6/6/2011)
SQLRNNR (6/6/2011)
Ray K (6/6/2011)
crookj (6/6/2011)
Daniel Bowlin (6/6/2011)
SQLRNNR (6/6/2011)
Ray K (6/3/2011)
Daniel Bowlin (6/3/2011)
Tom.Thomson (6/3/2011)
SQLRNNR (6/2/2011)
equineCeratorhine
Dasypine
Cat-o-nine
cat-o-tonic
That is exactly how I feel today.
cat-a-strophic
Joe
cat-en-ate
(or is it con-cat-en-ate?)
1 of 2 replies for this
Either
Mouse
or
detonate
OBLITERATE!!!!!!
Joe
I think...
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
June 6, 2011 at 12:06 pm
Ray K (6/6/2011)
crookj (6/6/2011)
Daniel Bowlin (6/6/2011)
SQLRNNR (6/6/2011)
Ray K (6/3/2011)
Daniel Bowlin (6/3/2011)
Tom.Thomson (6/3/2011)
SQLRNNR (6/2/2011)
equineCeratorhine
Dasypine
Cat-o-nine
cat-o-tonic
That is exactly how I feel today.
cat-a-strophic
Joe
cat-en-ate
(or is it con-cat-en-ate?)
1 of 2 replies for this
Either
Mouse
or
detonate
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
June 6, 2011 at 11:58 am
WayneS (6/6/2011)
SQLRNNR (6/6/2011)
Lynn Pettis (6/5/2011)
Jeff Moden (6/5/2011)
Lynn Pettis (6/4/2011)
I am going...
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
June 6, 2011 at 10:56 am
Viewing 15 posts - 9,856 through 9,870 (of 19,560 total)