Viewing 15 posts - 8,626 through 8,640 (of 22,214 total)
Oops. Log. I missed that. Sorry.
No, there's no more benefit there. But I wouldn't panic until you see log latch waits indicating that you're actually seeing a log write bottleneck....
March 19, 2014 at 4:57 am
Jampandu (3/18/2014)
Going with snapshot isolation require lot of changes in other procedures as I...
March 19, 2014 at 4:55 am
You'd have to modify the WHERE clause, the name is right there in the query:
ind.[name] IndexName,
March 19, 2014 at 4:51 am
I don't have personal hard tests to validate this, but yes, that's Microsoft's recommendations. However, the document I had for reference has been taken offline by Microsoft. It was here,...
March 19, 2014 at 4:42 am
If the user you're referencing in EXECUTE AS doesn't exist in the database, and have the permissions you're anticipating, combined with the user making the call not being a system...
March 19, 2014 at 4:29 am
For more info on all the date and time functions check out the documentation at Microsoft.
March 19, 2014 at 4:25 am
Breaking in is very difficult. There are very few junior DBA positions out there that will take you from knowing little and grow you into knowing a lot. The best...
March 19, 2014 at 4:21 am
If you observe the wait statistics through sys.dm_os_wait_stats, you'll be able to tell where the waits are occurring. If you see log latch and IO waits, then you're experiencing slower...
March 19, 2014 at 4:17 am
It's a pretty manual task because there's almost no way to determine precisely, programmatically, where to put the silly things. So I've always done what the others do. Put them...
March 19, 2014 at 4:13 am
Modifying data structures by creating a new table, moving the data, rename the old table, drop all the old constraints, recreating all constraints and indexes, rename the new table, drop...
March 19, 2014 at 4:10 am
The optimizer will know that an index is unique and may use that as part of it's decision process when putting together the execution plan.
March 19, 2014 at 4:06 am
The command you're looking for in T-SQL is called MERGE. Here's the Books Online entry on it.
March 19, 2014 at 4:05 am
sunil88_pal88 (3/18/2014)
There is one more thing I forget to tell that on development server ,everything is fine .Data is uploaded in almost 3 minutes, but on production it...
March 18, 2014 at 10:05 am
If you capture query metrics and the wait statistics from those queries at the same time, you can then correlate from wait statistics directly to queries. But, that's got to...
March 18, 2014 at 4:22 am
If WorkID is staying an identity column, then, you're guaranteed that the combination of WorkID and WorkDate are still identical because WorkID will always still be identical. But maybe I...
March 18, 2014 at 4:17 am
Viewing 15 posts - 8,626 through 8,640 (of 22,214 total)