Gail Shaw

Forum Replies Created

Viewing 15 posts - 14,086 through 14,100 (of 49,552 total)

RE: How to change the named instance name to default instance name on SQL Server 2008 R2?

Upgrade the 2005 instance to 2008 R2, move the databases over from the named instance, uninstall the named instance.

March 1, 2013 at 10:45 am

#1592490
RE: does index also change the output?

opc.three (3/1/2013)
GilaMonster (3/1/2013)
opc.three (3/1/2013)
My comment was that the yield from the FROM, WHERE, GROUP BY and HAVING clauses is not altered based on which index the engine picks.
I can probably...

March 1, 2013 at 10:44 am

#1592488
RE: does index also change the output?

opc.three (3/1/2013)
My comment was that the yield from the FROM, WHERE, GROUP BY and HAVING clauses is not altered based on which index the engine picks.
I can probably produce you...

March 1, 2013 at 10:34 am

#1592477
RE: How to change the data retention period from 5 yr to 20yrs in SQL 2005

What do you mean by 'retention period'? SQL Server has no automatic purging or data retention features (except around job history and the like)

March 1, 2013 at 10:23 am

#1592474
RE: does index also change the output?

sqldba_newbie (3/1/2013)
Jeff Moden (3/1/2013)
opc.three (3/1/2013)
Jeff Moden (3/1/2013)
Actually, the change of an index CAN very much change the result especially where UPDATEs are concerned.
I think we covered the OP's question about...

March 1, 2013 at 10:20 am

#1592473
RE: does index also change the output?

opc.three (3/1/2013)
Jeff Moden (3/1/2013)
Actually, the change of an index CAN very much change the result especially where UPDATEs are concerned.
I think we covered the OP's question about SELECT statements so...

March 1, 2013 at 6:59 am

#1592361
RE: SAN to SAN hardware level (Block Level) replication solution for MSSQL 2008 R2 databases synchronization between DR and Production

First ensure that the SAN replication preserves write order and is certified to work with SQL Server databases. If not, then you've got a russian roulette DR solution there. Also...

March 1, 2013 at 3:56 am

#1592303
RE: does index also change the output?

sqldba_newbie (2/28/2013)
I was in an assumption that index would only change the execution plan and not the actual output of the data. I have a query which gives completely different...

March 1, 2013 at 3:02 am

#1592289
RE: Estimated Execution Plan Curiosity

Estimated values are estimates based on what the QO knows of the query. They can be very wrong indeed.

February 28, 2013 at 2:10 pm

#1592185
RE: Applying checkpoint

The login needs to be sysadmin or to have db_owner or backup admin fixed server roles on the database where the checkpoint is run. If you are running checkpoint against...

February 28, 2013 at 1:10 pm

#1592175
RE: Applying checkpoint

From Books Online:
Permissions
CHECKPOINT permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles, and are not transferable.

February 28, 2013 at 12:16 pm

#1592154
RE: Adding an extra file to TEMPDB

ScottPletcher (2/28/2013)
GilaMonster (2/28/2013)
ScottPletcher (2/28/2013)
GilaMonster (2/28/2013)
ScottPletcher (2/28/2013)
If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a waste...

February 28, 2013 at 11:28 am

#1592138
RE: Adding an extra file to TEMPDB

ScottPletcher (2/28/2013)
GilaMonster (2/28/2013)
ScottPletcher (2/28/2013)
If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a waste of resources...

February 28, 2013 at 11:06 am

#1592125
RE: Adding an extra file to TEMPDB

ScottPletcher (2/28/2013)
If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a waste of resources vs just...

February 28, 2013 at 10:48 am

#1592108
RE: Restore log stop at option

Admingod (2/28/2013)
But you can still do without STOPAT clause right?
Not if you want to stop in the middle of a log backup. If your log backups are hourly and you...

February 28, 2013 at 10:38 am

#1592100

Viewing 15 posts - 14,086 through 14,100 (of 49,552 total)