Viewing 15 posts - 17,836 through 17,850 (of 19,560 total)
Jeffrey Williams-493691 (1/26/2010)
CirquedeSQLeil (1/26/2010)
Paul White (1/26/2010)
The Dixie Flatline (1/26/2010)
You're an evil man, Emperor Paulpatine.... :laugh:
Oh so The Dixie Flatline *is* Bob! I missed the transition somewhere...d'oh!
Thanks 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
January 26, 2010 at 9:44 pm
The basis of the question was to direct which answer to provide. If data load, then an ETL type process. If it was just a bunch of sql...
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
January 26, 2010 at 9:41 pm
Paul White (1/26/2010)
The Dixie Flatline (1/26/2010)
You're an evil man, Emperor Paulpatine.... :laugh:Oh so The Dixie Flatline *is* Bob! I missed the transition somewhere...d'oh!
Thanks for the high compliment!
What...
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
January 26, 2010 at 9:36 pm
Fraggle-805517 (1/26/2010)
However, I am still curious to know the answer to the question. I would rather have the 15 GB database on the 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
January 26, 2010 at 9:33 pm
Paul White (1/26/2010)
Steve Jones - Editor (1/26/2010)
Too late to nudge, someone answered. I wish they wouldn't do that. Encourages laziness.Someone?!?! :ermm:
You encourager of laziness and evil 😀
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
January 26, 2010 at 9:29 pm
Fraggle-805517 (1/26/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
January 26, 2010 at 9:27 pm
Backing up the database will only backup the used portion of the data file and then restore that portion. The extra time to process is due to creating the...
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
January 26, 2010 at 9:19 pm
Fraggle is spot on. Just assign your date to the variable and then re-use the variable throughout the code.
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
January 26, 2010 at 9:08 pm
Jeff Moden (1/26/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
January 26, 2010 at 8:56 pm
Here is a commercial product that may help:
http://www.devlib.net/decryptsql.htm
and another site that offers some information
http://www.sql-shield.com/decrypt-stored-procedure.html
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
January 26, 2010 at 5:59 pm
NP.
If you have the Primary already split into multiple files - no problems at all. I think you would have no problem being able to transfer the data within...
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
January 26, 2010 at 5:32 pm
If you are comfortable moving the data to a different filegroup, I think you would be OK doing it within the same filegroup. It is really the same process...
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
January 26, 2010 at 5:21 pm
Thanks Edogg.
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
January 26, 2010 at 5:06 pm
Steve Jones - Editor (1/26/2010)
I was just wondering about that after I posted. Need to check if a rebuild of the CI does distribute across files.
I am trying to recall...
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
January 26, 2010 at 5:03 pm
balbirsinghsodhi (1/26/2010)
Great.. That's what I want.Thank you guys.
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
January 26, 2010 at 5:02 pm
Viewing 15 posts - 17,836 through 17,850 (of 19,560 total)