Viewing 15 posts - 13,276 through 13,290 (of 19,560 total)
After you create the file, rebuild the clustered index for the table. If you want the entire table to be moved to the new file, you would 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
July 18, 2010 at 2:31 pm
The difference would be persistence. The table created in tempdb without the # would persist until the SQL service was restarted. The table created with the # 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
July 18, 2010 at 2:21 pm
and shiver like a giddy kid mid winter
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
July 17, 2010 at 11:03 pm
ALZDBA (7/17/2010)
Paul White NZ (7/17/2010)
CirquedeSQLeil (7/17/2010)
Tom.Thomson (7/17/2010)
Alvin Ramard (7/17/2010)
Steve Jones - Editor (7/17/2010)
I'm rubber and you all are glue....And we'll soon find out that it's true ...
But I'll stretch and...
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
July 17, 2010 at 2:37 pm
Tom.Thomson (7/17/2010)
Alvin Ramard (7/17/2010)
Steve Jones - Editor (7/17/2010)
I'm rubber and you all are glue....And we'll soon find out that it's true ...
But I'll stretch and sick to you
Hence, your face...
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
July 17, 2010 at 11:16 am
Steve Jones - Editor (7/15/2010)
A few pieces of advice:
- praise in public, criticize in private, even in the team.
- bad 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
July 16, 2010 at 12:53 pm
I'm glad this was republished. Thanks Jack - good explanation.
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
July 16, 2010 at 12:45 pm
Like others have said - get your server firewalled. I would recommend that you also change your TCP port for SQL server to something other than 1433.
I would also...
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
July 16, 2010 at 8:09 am
Maybe this question has come about again due to a lack of contributions...
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
July 15, 2010 at 11:04 pm
Lynn Pettis (7/15/2010)
Agreed, work has kept me busy too. May be starting a new job in August that should actually open up my evenings and weekends some.
Oh really? 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
July 15, 2010 at 10:53 pm
Kingston recommended a very good resource. I would also recommend the same book.
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
July 15, 2010 at 10:52 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
July 15, 2010 at 7:37 pm
Try one of the following:
1. Right-click on your textbox with the date in it, and go to Properties. In the Format tab, enter this as your format 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
July 15, 2010 at 7:24 pm
No. You will need a 64 bit platform and processor.
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
July 15, 2010 at 7:16 pm
This can work just fine for you as you explained. I would recommend that you try to get as much memory as you can. What kind of Shared...
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
July 15, 2010 at 7:12 pm
Viewing 15 posts - 13,276 through 13,290 (of 19,560 total)