Viewing 15 posts - 18,511 through 18,525 (of 19,560 total)
If you can modify the source table to include a column to control synchronization, that would be most excellent.
IsSynched = 1 in source, then SSIS ignores it and does anything...
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
December 22, 2009 at 2:51 pm
Lynn Pettis (12/22/2009)
Good to know. Thank you. Have you thought about writing this up as an article for ssc? You should.
I second the motion.:cool:
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
December 22, 2009 at 2:47 pm
sturner has offered some good advice.
In addition, by doing this up front - you may save yourself some administration time down the road. Before doing, you will need 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
December 22, 2009 at 2:43 pm
acapucion (12/22/2009)
Developer wanted to have capability to design SSIS, so I installed him BIDS...
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
December 22, 2009 at 2:39 pm
tbrun (12/22/2009)
the create object isn't the error i'm getting .. but i'll try this anyway.
But...
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
December 22, 2009 at 2:38 pm
Jeff Moden (12/22/2009)
CirquedeSQLeil (12/22/2009)
...And chastising QODs:blush:
Heh... nah... "tweeking" is the word that I would chose on the one you're thinking of. 😀 I bashed one that Steve posted...
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
December 22, 2009 at 2:28 pm
Jeff Moden (12/22/2009)
CirquedeSQLeil (12/22/2009)
Bru Medishetty (12/22/2009)
CirquedeSQLeil (12/22/2009)
Bru Medishetty (12/22/2009)
http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx
Recollect some of his / her famous threads.
Lock Pages in Memory
How...
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
December 22, 2009 at 2: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
December 22, 2009 at 2:19 pm
Jeff Moden (12/22/2009)
GSquared (12/22/2009)
Lynn Pettis (12/22/2009)
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
December 22, 2009 at 2:16 pm
As a side-note, it is recommended to upgrade to SMO. Though the Backward compatibility pack exists, it is not guaranteed to be included as an option with future releases...
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
December 22, 2009 at 2:11 pm
Sometimes you will need to manually register sqldmo.dll in C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll using regsvr32. For example, if you get the Server.CreateObject Failed message, you will need to register 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
December 22, 2009 at 2:10 pm
Lynn Pettis (12/22/2009)
GilaMonster (12/22/2009)
Bru Medishetty (12/22/2009)
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
December 22, 2009 at 1:56 pm
You could empty the file of data to other files in the filegroup. Once that is complete, then you could remove the file and add another file in its...
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
December 22, 2009 at 1:50 pm
Lynn Pettis (12/22/2009)
CirquedeSQLeil (12/22/2009)
Bru Medishetty (12/22/2009)
Lynn Pettis (12/22/2009)
Hey, this is the BEST place to waste time. I enjoy my time out in the desert!
Which place are you from Lynn...
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
December 22, 2009 at 1:46 pm
After you remove the LUN, does your master database come up? MSDB? TEMPDB? MODEL?
What is the error message you get when trying to start the Agent?
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
December 22, 2009 at 1:41 pm
Viewing 15 posts - 18,511 through 18,525 (of 19,560 total)