Viewing 15 posts - 7,771 through 7,785 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 17, 2014 at 6:14 am
andrew gothard (9/17/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 17, 2014 at 5:39 am
INSERT INTO #DestinationTable
EXEC sp_executesql ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 17, 2014 at 2:34 am
jralston88 (9/16/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 16, 2014 at 1:01 pm
Viewing 15 posts - 7,771 through 7,785 (of 49,552 total)