Viewing 15 posts - 15,256 through 15,270 (of 49,552 total)
Probably best bet here is an extended events session with the bucketiser target.
This should help: http://sqlblog.com/blogs/jonathan_kehayias/archive/tags/XEvent+A+Day/default.aspx
December 12, 2012 at 10:36 am
Can you take a log backup?
Do you have all the log backups since the full last night?
December 12, 2012 at 10:35 am
The only thing that the compat level does is make certain query constructs behave as they did in the lower version. This does not mean that new functionality is disabled,...
December 12, 2012 at 10:28 am
So you didn't like our previous advice and decided to ask again. Sorry, same answer. Go and study for the damn cert and don't ask for us to help you...
December 12, 2012 at 5:46 am
itsmemegamind (12/12/2012)
1. Defrag you database2. Reorganising the indexes
3. Partitioning the database or also table
these operations will definitely improve your server performance and also the database space
Err, no, they won't.
December 12, 2012 at 5:36 am
bdeboer (12/12/2012)
December 12, 2012 at 3:00 am
Lowell (12/5/2012)
Deletes and Heaps
When data is deleted from a heap using a DELETE statement, SQL Server will not release the space; it remains allocated to the heap. This leads to...
December 12, 2012 at 2:56 am
sanandh87 (12/12/2012)
I want to do MCSA exam. Do any dump available for this? Please let me know.
Here's a novel idea... Study for it! Like the rest of us who hold...
December 12, 2012 at 2:52 am
If you have the update failing and you want the insert to be rolled back, then you need a transaction and error handling. Look up Begin transaction and Try... Catch.
Not...
December 12, 2012 at 2:01 am
Hemant.R (12/12/2012)
hi ,you can used copy_only option to take full backup. when transaction log backup job created for same database .
bcoz it will not break lsn squence of database .
Full...
December 12, 2012 at 1:58 am
Update won't fail because it takes too long either, neither will a delete.
If you have the update failing and you want the insert to be rolled back, then you need...
December 12, 2012 at 1:17 am
An insert or select won't fail because the server's slow. SQL by itself doesn't care how long a query takes. If the procedure is timing out, then it means that...
December 12, 2012 at 1:02 am
Timeout is a client-side setting, not a server side. It means the client has got tired of waiting and told SQL to cancel the execution.
December 12, 2012 at 12:54 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 12, 2012 at 12:49 am
Viewing 15 posts - 15,256 through 15,270 (of 49,552 total)