Viewing 15 posts - 14,341 through 14,355 (of 49,552 total)
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...
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.
February 9, 2013 at 10:50 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?
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/
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...
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...
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...
February 9, 2013 at 2:54 am
Mike Seattle (2/8/2013)
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...
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...
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.
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...
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
February 8, 2013 at 10:03 am
Viewing 15 posts - 14,341 through 14,355 (of 49,552 total)