Viewing 15 posts - 15,136 through 15,150 (of 19,560 total)
mangeshd (4/7/2010)
> Drop the existing publication and run sp_removedbreplication on dev server
> Run sp_dropdistribution to clean the distributor from dev server
>...
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 7, 2010 at 1:58 pm
Gibraltar no like Lynn. Taking her toys and going to play in another sandbox. 😀
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 7, 2010 at 1:57 pm
Lynn Pettis (4/7/2010)
CirquedeSQLeil (4/7/2010)
Lynn Pettis (4/7/2010)
Gibraltar strikes again. She really needs to learn some tact.Data Modeling discussion?
Yes.
Not too happy about 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 7, 2010 at 1:55 pm
Lynn Pettis (4/7/2010)
PaulB-TheOneAndOnly (4/7/2010)
GSquared (4/7/2010)SQL Server, as with any tool, has limitations.
Have you noticed how vendors usually call them "features" 😛
Sure have, they have to show their product in...
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 7, 2010 at 1:51 pm
You're welcome.
Keep us posted on what you find.
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 7, 2010 at 1:48 pm
Lynn Pettis (4/7/2010)
Gibraltar strikes again. She really needs to learn some tact.
Data Modeling discussion?
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 7, 2010 at 1:44 pm
Trey Staker (4/7/2010)
@jason, I too found it in Microsoft CRM, this doesn't surprise me there is always weird stuff in the CRM.
Why would anyone use Ansi Nulls off?
First, you're welcome.
Second...
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 7, 2010 at 1:41 pm
Paul White NZ (4/7/2010)
David Fulton-420388 (4/7/2010)
Paul White NZ (4/7/2010)
David Fulton-420388 (4/7/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 7, 2010 at 12:20 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
April 7, 2010 at 12:16 pm
ben.mcintyre (4/7/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 7, 2010 at 12:15 pm
WayneS (4/6/2010)
Rafael A. Colon (4/6/2010)
... In our Company we have a separate Data Management team that deals with all the issues related to data...Must be nice. Really nice. 🙂
We have...
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 7, 2010 at 12:14 pm
Check with someone that is responsible for the data, or its use, and confirm with them that you are making the correct changes.
Sound advice. Even though I am responsible...
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 7, 2010 at 12:13 pm
Pranav Shah-410191 (4/7/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 7, 2010 at 12:09 pm
Thanks Lowell for a superb script.
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 7, 2010 at 12:02 pm
I would take the production database from your primary server and restore the backup of that database to the dev server. Make sure to rip out any replication related...
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 7, 2010 at 11:49 am
Viewing 15 posts - 15,136 through 15,150 (of 19,560 total)