Viewing 15 posts - 14,341 through 14,355 (of 49,552 total)
First section
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
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
February 9, 2013 at 3:20 pm
SQL_Surfer (2/9/2013)
2) If I delete the records from the underlying table, will they still be stored in the partions? Is it the real application of the partions?
Err... you may 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
February 9, 2013 at 1:48 pm
The primary key can be made non-clustered, however any unique index (and that includes the pk) must have the partition key as part of the index key.
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
February 9, 2013 at 10:50 am
How do you get from 10000 to 200%? And what does a salary of 200% mean? 200% of what?
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
February 9, 2013 at 10:18 am
rajeshjaiswalraj (2/9/2013)
In 15th line.... just remove >10 and give >0WHERE migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) > 0
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
February 9, 2013 at 9:48 am
There's a bug in the missing index DMVs that results in them showing indexes that exist (absolutely identical ones)
http://www.sqlskills.com/blogs/paul/missing-index-dmvs-bug-that-could-cost-your-sanity/
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
February 9, 2013 at 9:48 am
I assume you mean 2008 R2, as there was no SQL Server 2004.
If the delete was done within a transaction and the transaction has not been committed, then Rollback will...
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
February 9, 2013 at 5:37 am
winmansoft (2/9/2013)
So anyone who can login to SSMS can easily decrypt database by using it.
Only if they have permission to open the key. The encryption is managed using standard SQL...
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
February 9, 2013 at 2:59 am
1) Yes. It's Read committed isolation level using row versions, it allows all the same data anomalies as read committed does.
2) You don't need to manage the version store, just...
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
February 9, 2013 at 2:54 am
Mike Seattle (2/8/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
February 9, 2013 at 2:20 am
Run checkpoint and check sys.databases again. The log_reuse doesn't update instantly. Probably the transaction ran out of log space and was rolled back, hence why it's no longer active.
Maybe take...
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
February 9, 2013 at 2:12 am
koustav_1982 (2/8/2013)
studied the mcts book thoroughly for a month and solved some dumps from net.
Braindumps are cheating. They are actual questions taken from the exams in violation of the NDA...
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
February 9, 2013 at 1:29 am
If it's progressing and time's not of the essence (which it apparently isn't), just wait.
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
February 8, 2013 at 10:42 am
parminder.parmindersingh (2/8/2013)
But if i restart the server or SQL services all recovery will undo. Then what is benefit of restart Server?
Currently the schedulers are hung. If all of them...
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
February 8, 2013 at 10:16 am
Data files other than the primary by convention get the extension .ndf
The fill method it proportional fill. You can google for the intricate details if you wish
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
February 8, 2013 at 10:03 am
Viewing 15 posts - 14,341 through 14,355 (of 49,552 total)