Viewing 15 posts - 17,851 through 17,865 (of 19,560 total)
Steve Jones - Editor (1/26/2010)
Existing data won't move, but as you add new data/objects, they will distribute across the four drives.
True. I think that you can manipulate that, however....
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 4:57 pm
Yes you could. You would need to create 3 more files for the primary filegroup, with each one created on a different drive / lun / raid.
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 4:39 pm
WayneS (1/26/2010)
jameslester78-958147 (1/21/2010)
Mishi Kobe Niku, what is it?
And all I could think of (all the while knowing it was wrong) was Star Trek, Capt. Kirk, and the no-win simulation he...
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 3:45 pm
Venkata, unless I am missing the boat on this one, I recently blogged about a similar scenario I ran into that required some date matching.
Check it out at:
http://jasonbrimhall.info/?p=193
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 3:43 pm
Lynn Pettis (1/26/2010)
Alvin Ramard (1/26/2010)
Alvin Ramard (1/26/2010)
Alvin Ramard (1/26/2010)
I cou'dn't resist in this one as the OP did not ask a question. 😎http://www.sqlservercentral.com/Forums/Topic853917-392-1.aspx?Update=1
Edit: Oops, I missed the "Pl...
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 3:33 pm
No Problem.
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 3:22 pm
Alvin Ramard (1/26/2010)
I haven't been paying much attention to the forums lately, but I have been checking regularly today. :w00t:I'm ready to return to the desert!!!!
I think this week has...
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 1:20 pm
Try the following:
http://jasonbrimhall.info/?p=97
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 1:19 pm
Thanks for the question and the reminder on this type of pattern matching.
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 12:38 pm
John McC (1/26/2010)
DOH missed Jim at the top...
I nearly did the same thing - had to reread the list of names. If you see Jim at the top, 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
January 26, 2010 at 12:37 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
January 26, 2010 at 12:35 pm
With the contents being various different sql commands and statements, I would opt for breaking the file out. 200MB seems somewhat large for a script file - unless it...
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 12:14 pm
Here is script that I prefer to use than what you are using.
Run this and let me know if the filegroups show differently in it.
with tablesize as (
select so.Name 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
January 26, 2010 at 12:12 pm
Is this a bulk load script or is the script file various different sql statements and commands?
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 11:49 am
Colts + 21
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 11:40 am
Viewing 15 posts - 17,851 through 17,865 (of 19,560 total)