Viewing 15 posts - 15,886 through 15,900 (of 49,552 total)
The estimations from an equality where there's no parameter sniffing is based on the average density of the column. The estimations for an inequality where there's no parameter sniffing is,...
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
October 30, 2012 at 2:19 am
Good indexes, efficiently written queries, good database design.
If there's locking problems, tune queries, tune indexes, consider one of the snapshot isolation levels.
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
October 30, 2012 at 2:17 am
Couple million's small, but no, modifying indexes is not a good idea when the server is in use.
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
October 29, 2012 at 4:43 pm
BEGIN TRANSACTION
ALTER TAble Table1
drop PK_Table1
ALTER TABLE Table1
ADD CONSTRAINT [PK_Table1]
PRIMARY KEY CLUSTERED
(
[ID] ASC
)
COMMIT TRANSACTION
Please in future post new questions in a new thread. Thanks
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
October 29, 2012 at 4:13 pm
There are very seldom materials specifically for the upgrade exams. Look for materials for the non-upgrade 2012 exams and use those.
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
October 29, 2012 at 10:58 am
If you have CDC and no replication, then there's technically no 'unreplicated' transaction as it's CDC that's behind/failing, not replication. They use the same method to get transactions, that's why...
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
October 29, 2012 at 5:06 am
The pages aren't moved from memory to disk, (there's a page on disk and a copy of that page in memory), but checkpoint writes at a page level, not the...
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
October 29, 2012 at 3:11 am
Mac1986 (10/29/2012)
Quick Question: I have seen a situation where the there is no replication setup on the DB...
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
October 29, 2012 at 3:09 am
You need to identify why that CDC job is failing. That job failing will cause the log to fill because the log space cannot be marked reusable until the CDC...
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
October 29, 2012 at 3:09 am
Mac1986 (10/29/2012)
Lets say if the drive is full, what options do we have apart from growing the mount point capacity.
Or is there a way to match the LSN...
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
October 29, 2012 at 1:09 am
No, it won't be a run-away query. Query execution is not logged to the tran log, many-to-many joins do not write to the transaction log of the DB (maybe...
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
October 29, 2012 at 1:06 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
October 29, 2012 at 1:02 am
It'll be the same as the active instance. They're stored in master, the master DB is shared in a cluster, hence settings are identical.
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
October 26, 2012 at 11:36 am
SELECT sod.SalesOrderID ,
SalesOrderDetailID ,
AccountNumber = (SELECT AccountNumber FROM Sales.SalesOrderHeader soh WHERE soh.SalesOrderID =...
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
October 26, 2012 at 10:40 am
New thread in the appropriate forum. Probably SQL 2005 T-SQL. Some people will look at a thread with lots of replies and not check it, assuming it's answered already.
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
October 26, 2012 at 9:43 am
Viewing 15 posts - 15,886 through 15,900 (of 49,552 total)