Viewing 15 posts - 12,331 through 12,345 (of 49,552 total)
Sean Lange (7/17/2013)
The next issue is top(1000). You have no order by so there is no way to know which 1000 it will delete.
You can't put an Order By on...
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
July 17, 2013 at 3:58 pm
One for each level of the index.
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
July 17, 2013 at 3:33 pm
Try starting with the sys.dm_db_partition_stats DMV. That will give you page counts per index, you can expand from there.
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
July 17, 2013 at 10:53 am
As you pointed out, the website says the exam will be expiring (ie no longer available) on July 31. Hence no, you will not be able to write it after...
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
July 17, 2013 at 10:20 am
ChrisM@Work (7/17/2013)
Really? What type of join is shown for Query 1 and Query 2?
NOT IN and NOT EXISTS do perform identically with identical execution plans if the columns are...
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
July 17, 2013 at 7:51 am
S_Kumar_S (7/17/2013)
ok, I am attaching the error image..
Not enough information.
Run the restore from a T-SQL query window and post the complete output.
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
July 17, 2013 at 7:49 am
HanShi (7/17/2013)
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
July 17, 2013 at 6:56 am
Full backups do not and never have affected the LSN chain for log backups in any way, means, guise or form (with the sole exception of the first full backup...
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
July 17, 2013 at 6:54 am
The plan cache, as well as all the other caches are part of the buffer pool.
The pre-allocate of MemToLeave is only on 32-bit SQL and the memory management has changed...
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
July 17, 2013 at 6:51 am
Brandie Tarvin (7/17/2013)
The script it gave me is looking at dbo.sysobjects for default constraints, and since the constraints aren't in dbo.sysobjects, it's not dropping them at all.
All constraints are in...
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
July 17, 2013 at 6:46 am
No, that will require a scan of both tables.
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
July 17, 2013 at 4:28 am
Read up on SQLAudit, Change data capture, change tracking, see if any of them do what you want.
If you're considering a trace for all DDL operations, that can get huge....
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
July 17, 2013 at 2:46 am
Server has between 4 and 8GB of memory and is 32-bit. Even then it's not required, just optional.
Above 8GB, you want /PAE only due to what /3gb does to 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
July 17, 2013 at 2:38 am
For that you would have needed to have a trace running over the time period you're interested in. SQL does not record DML statements by default. For DDL, you might...
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
July 17, 2013 at 2:01 am
Please read through this - Managing Transaction Logs[/url]
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
July 17, 2013 at 1:50 am
Viewing 15 posts - 12,331 through 12,345 (of 49,552 total)