Viewing 15 posts - 18,586 through 18,600 (of 19,560 total)
Gus has some valid points. Amongst those is the double posting. When posting the question, if you double post - it will just add to your frustration as...
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 21, 2009 at 1:12 pm
Given the updated information, the solution provided by Lynn is what you need.
Curse you Lynn for beating me to the punch again 😉
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 21, 2009 at 1:09 pm
HAHA
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 21, 2009 at 1:07 pm
Lynn Pettis (12/21/2009)
Joe-420121 (12/21/2009)
1. Create Table [backup12212009] with BIGINT Indentity
2. using SSIS export data from old table to [backup12212009]
3. Delete old table
4. Rename backup12212009
Can do as...
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 21, 2009 at 1:03 pm
Lynn Pettis (12/21/2009)
How many more ways can the same question be asked?http://www.sqlservercentral.com/Forums/Topic837454-148-1.aspx
http://www.sqlservercentral.com/Forums/Topic837318-148-1.aspx
http://www.sqlservercentral.com/Forums/Topic837385-338-1.aspx
Sounds like a riddle - are you plucking petals from a flower as you count the ways? I...
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 21, 2009 at 12:52 pm
Or look at the other thread on that rahulsony111 started
http://www.sqlservercentral.com/Forums/Topic837454-148-1.aspx#bm837479
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 21, 2009 at 12:43 pm
Thanks - will do.
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 21, 2009 at 12:41 pm
Lynn Pettis (12/21/2009)
CirquedeSQLeil (12/21/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 21, 2009 at 12:38 pm
Thanks Gus. I was hoping for that kind of response.
Along the code copy comment - It would be nice to be able to use the ifCode for SQL 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
December 21, 2009 at 12:36 pm
I'm curious what the need is to convert a date to a Number. I would leave the date as one of the datetime datatype in sql 2005.
Now to get...
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 21, 2009 at 12:33 pm
Good to know.
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 21, 2009 at 12:29 pm
Good Point Homebrew - It is a better practice in most cases to create the table first.
If all is broken currently because nothing can be inserted into the table, then...
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 21, 2009 at 12:25 pm
I agree with Steve. I would prefer to have extra security on the laptops - not to the level of fully encrypting the entire hard drive. Security as...
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 21, 2009 at 12:21 pm
GilaMonster (12/21/2009)
gk-411903 (12/21/2009)
Does this mean that ONLY the index is moved to TSTDB_Idx but the data part is stillremaining in the PRIMARY file group?.
No. That's index 1, the clustered index....
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 21, 2009 at 12:03 pm
NP
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 21, 2009 at 11:56 am
Viewing 15 posts - 18,586 through 18,600 (of 19,560 total)