Viewing 15 posts - 25,696 through 25,710 (of 49,552 total)
GilaMonster (6/6/2011)
Or look at SQLCMD mode. There's no T-SQL command that will let you switch instances
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 11:59 am
SELECT TOP (10) <column list>
FROM <Some Table>
ORDER BY <Whatever columns defines the ordering you want>
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 11:59 am
Profiler for aggregated totals (for statement or batch depending on event), Statistics IO for a per-table breakdown.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 10:18 am
SET STATISTICS IO ON, then run the query.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 10:08 am
opc.three (6/6/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 10:07 am
Do you have an ORDER BY?
If not, SQL makes absolutely no guarantees about the ordering that the data will be returned in. It'll be whatever order the rows are based...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 9:26 am
Disconnect and reconnect. Or look at SQLCMD mode. There's no T-SQL command that will let you switch instances
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 8:34 am
If you're just getting started with indexes, maybe this will be a good read (3 parts in total) http://www.sqlservercentral.com/articles/Indexing/68439/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 8:29 am
roger.plowman (6/6/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 8:21 am
Well you have a choice.
Disable the log backup maintenance plan
Disable log shipping
You need to do one of those. Which one is up to you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 7:01 am
For virtual memory, I recommend these:
http://channel9.msdn.com/Events/PDC/PDC10/CD01
http://channel9.msdn.com/Events/PDC/PDC10/CD02
None of the topics you've asked about are basic, simple or trivial to explain. I suggest you start with google and do a lot of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 7:00 am
It is a purely informational message and no user intervention of any form is required.
All it's telling you is at which point the snapshot for the checkDB was split away...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 6:43 am
That is never going to work.
To restore logs, you need an unbroken chain of log backups. Each log backup is based on the previous log backup. By setting up two...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 6:40 am
muthukkumaran Kaliyamoorthy (6/6/2011)
Only if your update changes the key values.
So this also true, Because the replication nees a primary key to setup.
Yes, l replication needs a key, but it doesn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 6:38 am
So you're taking normal log backups as well as the log backups taken by the log shipping?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 6:04 am
Viewing 15 posts - 25,696 through 25,710 (of 49,552 total)