Viewing 15 posts - 14,641 through 14,655 (of 49,552 total)
Little tighter than I like, but should be OK. Just specify sort in temp DB (assuming TempDB's on another drive or has decent free space)
January 24, 2013 at 10:19 am
poratips (1/24/2013)
We have Database AUENG and tables called AUSM it has two date columns and it's very big table and we would like to make a partition table.
Why?...
January 24, 2013 at 10:17 am
Undocumented means just that, it's not listed in the official documentation (BoL). Some things are mentioned in kb articles, some in discussions with MS engineers or devs. Some can be...
January 24, 2013 at 9:24 am
ben.brugman (1/24/2013)
January 24, 2013 at 9:18 am
Right, so the TempDB usage is not due to the reorg using TempDB, it's the snapshot isolation and the row version store.
To be honest, I'm not 100% sure how the...
January 24, 2013 at 7:17 am
runal_jagtap (1/24/2013)
will perfom the below activity..
1) Full Backup - Using manitenencae plan
2) Transaction Log Backup - Using manitenencae plan
3) Truncate Logs (this grows up...
January 24, 2013 at 6:01 am
SQL* (1/24/2013)
High availability : Means 99.99% of times data must be available.
By who's definition? 4 nines is too much for some, not enough for others. Your uptime requirements for HA...
January 24, 2013 at 5:59 am
WolfgangE (1/24/2013)
Our tempdb-database is configured having 8 data files. As Microsoft recommends we have one data file for each core, all having same file size and grow rate.
When we start...
January 24, 2013 at 5:53 am
james marriot (1/24/2013)
e.g create...
January 24, 2013 at 4:58 am
Bhuvnesh (1/24/2013)
Order table will have index on InvoiceID and InvoiceNumberOrderLines will have ix_test on orderLines(InvoiceId, ProductID,status) Include(.....)
Not the most efficient order for the columns within...
January 24, 2013 at 4:54 am
Very likely has nothing whatsoever to do with the execution plan. 15 seconds is far longer than SQL takes to compile anything other than a ridiculously complex query.
Restarting cleared the...
January 24, 2013 at 4:49 am
Wait until whatever is using the rows has finished and the locks are released. If there's an orphaned transaction locking the rows, check with DBCC OpenTran and investigate whether or...
January 24, 2013 at 4:47 am
jitendra.padhiyar (1/24/2013)
now its in normal online mode, and can access it...
January 24, 2013 at 4:45 am
emile.milne (1/23/2013)
If I want to tweak the index for reports they...
January 23, 2013 at 11:44 pm
Much easier to use fn_trace_gettable and then filter within SQL. The profiler GUI's a pain to filter, sort and search in.
January 23, 2013 at 11:36 pm
Viewing 15 posts - 14,641 through 14,655 (of 49,552 total)