Viewing 15 posts - 10,471 through 10,485 (of 19,560 total)
If you have multiple files on the same filegroup - your table will be spread across those files. You can see this happening when you rebuild a 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
April 12, 2011 at 12:34 pm
Geoffrey Wrigg (4/12/2011)
1) The question is, what particular privileges are needed to get the upgrade to work?
A system administrator or sa is required to perform the upgrade.
2) Does 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
April 12, 2011 at 12:26 pm
Brandie Tarvin (4/12/2011)
CirquedeSQLeil (4/12/2011)
Brandie Tarvin (4/12/2011)
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
April 12, 2011 at 12:19 pm
Brandie Tarvin (4/12/2011)
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
April 12, 2011 at 12:13 pm
In the paths to where you moved the master db files, did you name the folder structure in accordance to the Instance name?
E.g. mssqlserver\Instance1 would be C:\DatabasePath\Instance1\... or something...
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
April 12, 2011 at 11:54 am
I really thought this dilemma was answered. Are we beating a dead-horse now?
If not, what exactly is the debate at this point?
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
April 12, 2011 at 11:37 am
opc.three (4/12/2011)
CirquedeSQLeil (4/12/2011)
you could look into doing an nslookup in combination with xp_cmdshellThat implies turning on xp_cmdshell which is off by default...for good reason.
That is true. There are 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
April 12, 2011 at 11:31 am
you could look into doing an nslookup in combination with xp_cmdshell
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
April 12, 2011 at 11:19 am
I agree here that you should stop shrinking. Also, it appears that you have some big processes that run nightly that are causing the data file to regrow (possibly...
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
April 12, 2011 at 11:02 am
I have never been able to query the resource database that way either - that is without restoring it as a different database.
Do you have multiple instances setup on 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
April 12, 2011 at 10:56 am
Dan.Humphries (4/12/2011)
crookj (4/12/2011)
Daniel Bowlin (4/12/2011)
Ray K (4/12/2011)
GilaMonster (4/11/2011)
Darkness (as in, 'the city is in ... ')Hello, darkness, my old friend . . .
I've come to talk with you again
And 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
April 12, 2011 at 10:51 am
Excellent question. This is a question that should be helpful to many database professionals.
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
April 12, 2011 at 10:46 am
Steve Jones - SSC Editor (4/12/2011)
You do not have to post to get points...
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
April 12, 2011 at 7:17 am
Hugo Kornelis (4/12/2011)
In the newsletter, the question is about nvarchar(30). On the site, the data type is nchar(30). Maybe Steve changed the question after seeing all the messages? Usually,...
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
April 12, 2011 at 7:16 am
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.What/who is it?
And what was wrong with the lizard?
Can't 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
April 11, 2011 at 9:33 pm
Viewing 15 posts - 10,471 through 10,485 (of 19,560 total)