Viewing 15 posts - 16,741 through 16,755 (of 49,552 total)
No, you don't want to shrink in 1 MB chunks...
Create 2 new files in the filegroup, then shrink the full one with EMPTYFILE and remove it. Result - data balanced...
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
September 8, 2012 at 11:21 am
biohug (9/8/2012)
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command....
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
September 8, 2012 at 10:58 am
Honestly, I would strongly recommend you don't go that route. It's going to be messy, a pain to code and maintain and a huge security risk.
The only way to do...
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
September 8, 2012 at 9:22 am
That looks like a corrupt backup.
Take a new backup and try again. What version is the SQL Express instance?
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
September 8, 2012 at 4:35 am
If the binary value does not change, the page is not marked dirty, the log record for the update is not written.
Page verify has no effect.
Page checksums are not calculated...
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
September 8, 2012 at 4:29 am
Lynn Pettis (9/7/2012)
Evil Kraig F (9/7/2012)
Lynn Pettis (9/7/2012)
Evil Kraig F (9/7/2012)
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
September 8, 2012 at 3:18 am
sqlnaive (9/7/2012)
For such kind of reasons we should avoid float and real datatypes ? And rather use decimal and numeric ?
No. Rather don't use string functions on values that 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
September 7, 2012 at 8:44 am
PageIOLatch waits are IO-related. It's a wait for the page to move from memory to disk or disk to memory.
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
September 7, 2012 at 8:42 am
PiMané (9/7/2012)
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
September 7, 2012 at 8:40 am
Shutdown just means that SQL has cleanly closed the database down. Usually because Auto_close is enabled and no one's using 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
September 7, 2012 at 3:32 am
sqldba4u (9/7/2012)
Max and Min memory have been setup and few GBs are left for OS. Clearing up cache is not releasing server memory.
No, it won't, because SQL does not give...
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
September 7, 2012 at 3:30 am
Backup is an IO bound operation. Either your DB has become significantly bigger (unlikely) or the source or destination drives for the backup are reading or writing slower. Check disk...
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
September 7, 2012 at 3:27 am
IN with a subquery performs identically to EXISTS
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
INNER JOINs perform slightly slower than IN
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
NOT in performs badly when the columns involved are nullable because there's a logical difference in their...
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
September 7, 2012 at 3:19 am
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
September 6, 2012 at 3:29 pm
Lynn Pettis (9/6/2012)
I guess we are supposed to be miracle workers here and know just what went wrong given minimal information.
With login failures the state is enough to diagnose 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
September 6, 2012 at 3:29 pm
Viewing 15 posts - 16,741 through 16,755 (of 49,552 total)