Viewing 15 posts - 7,771 through 7,785 (of 49,571 total)
I'll second the recommendation to read Glenn's stuff.
Processor caches are there to reduce the amount of times that a CPU is spinning idle waiting for data from memory. Small caches...
September 18, 2014 at 2:39 am
shahi.alokchandra (9/17/2014)
Actually i am having more then 100000 rows in table and if i use functions then my index might not be called.,that why want to avoid cases and functions.
You...
September 18, 2014 at 2:33 am
Try to restore it and see if the restore fails.
Restore HeaderOnly only looks at the header, so only if the header is damaged will it give any indication. Restore VerifyOnly...
September 18, 2014 at 2:31 am
I'd suggest you run a full CheckDB. Also review the success/failure of your regular CheckDB jobs, see when they started failing.
September 17, 2014 at 12:16 pm
monrroym (9/17/2014)
Which msdb table holds the specific list of databases to be backed up for the 'backup database task'?
None. Maint plans are SSIS packages. Follow the advice above about...
September 17, 2014 at 6:19 am
You have created the temp table before running that insert statement?
Insert doesn't create the destination table....
September 17, 2014 at 6:14 am
andrew gothard (9/17/2014)
September 17, 2014 at 5:39 am
INSERT INTO #DestinationTable
EXEC sp_executesql ...
September 17, 2014 at 4:52 am
enriquemallon (9/17/2014)
First problem is that it appears that the master database has either been moved, or deleted, or the folder has had all rights removed from the SQL Server's account.
If...
September 17, 2014 at 4:51 am
Bear in mind that in your case the pages were zeroed out (overwritten with zeroes), so unless a tool is capable of undoing that (which last I heard required a...
September 17, 2014 at 4:46 am
What's wrong with CASE? Yes, you can, but it becomes significantly less readable than the equivalent using CASE.
September 17, 2014 at 2:36 am
zedtec (9/16/2014)
Ok if the database owner is a valid AD user and is deleted from AD will there be any restrictions in this scenario?
That's the scenario I described...
September 17, 2014 at 2:34 am
jralston88 (9/16/2014)
September 16, 2014 at 2:16 pm
That's about right, maybe on the low side. In full recovery index rebuilds are size-of-data operations, so log usage equal or greater than the size of the index.
September 16, 2014 at 1:02 pm
Let's start with 'why'?
There is no truth to the myth that only one core can write to a particular file. All threads, no matter where they are running can read/write...
September 16, 2014 at 1:01 pm
Viewing 15 posts - 7,771 through 7,785 (of 49,571 total)