Viewing 15 posts - 16,096 through 16,110 (of 19,560 total)
Nice sample and explanation Dave and Bob.
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
March 22, 2010 at 1:19 pm
Michael Valentine Jones (3/22/2010)
If it is really a primary key, then you would not use the DROP INDEX statement.You would use
ALTER TABLE tablename DROP CONSTRAINT constraint_name
Good idea to point...
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
March 22, 2010 at 1:17 pm
sunny.tjk (3/22/2010)
I deleted the foreign key but I'm still not able to delete the primary key. Is it any way connected to the unique keys that I've on 3 columns?
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
March 22, 2010 at 1:13 pm
GSquared (3/22/2010)
When I was getting the new engagement ring, I joked with some friends, "Oh my God! What will I do if she says, 'no'?" 😀
You would have been...
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
March 22, 2010 at 1:11 pm
Steve Jones - Editor (3/22/2010)
Have to be close to home as a cranky Steve on the road might not get another "I do" 🙂
I think a Cranky [any person] would...
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
March 22, 2010 at 1:08 pm
I think we need to be careful here. I would keep the list short. You don't want to have to answer 20 questions about your question just 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
March 22, 2010 at 1:06 pm
Have you tried to install them on a different machine?
Is this a fresh install of 2k8 as well?
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
March 22, 2010 at 1:02 pm
SilverHawks
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
March 22, 2010 at 12:50 pm
sunny.tjk (3/22/2010)
An explicit DROP INDEX is not allowed on index 'dbo.PAYMENTS_tmp.PK_Payments_tmp'. It is being...
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
March 22, 2010 at 12:45 pm
Here is a blog that should prove useful.
http://blogs.technet.com/andrew/archive/2008/03/30/sql-server-2008-best-practice.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
March 22, 2010 at 12:43 pm
rkinney-802645 (3/22/2010)
Hi all.Found info on http://msdn. microsoft. com/en-us/ library/ms191545 (SQL.90). aspx .
Thanks,
RKinney
Thanks for posting back.
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
March 22, 2010 at 12:38 pm
love sql (3/22/2010)
Could you please tell me anyone that what is the difference between querying data from remote server and linked server.
performance wise as well. What are the things...
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
March 22, 2010 at 12:36 pm
It should also include the dark mists around it.
There must be some corruption issues out there with lame duck responses from others.
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
March 22, 2010 at 12:30 pm
Thanks for posting back.
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
March 22, 2010 at 12:26 pm
Alvin Ramard (3/22/2010)
CirquedeSQLeil (3/22/2010)
Alvin Ramard (3/22/2010)
I'm going to see if I can prepare myself for:...
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
March 22, 2010 at 12:22 pm
Viewing 15 posts - 16,096 through 16,110 (of 19,560 total)