Viewing 15 posts - 27,796 through 27,810 (of 49,552 total)
sql_butterfly (2/14/2011)
I'm planning to use SET TRANSACTION ISOLATION LEVEL SNAPSHOT before update. Will it help me avoid deadlocks ?
Yes. Just make sure that your code can handle and retry in...
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
February 14, 2011 at 2:00 am
crazy4sql (2/14/2011)
is the location exist which is mentioned for backup? Seems like the path is no more accessible.
The non-recoverable IO error is on the data file, not the backup file.
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
February 14, 2011 at 1:39 am
What was the details of the suspect state (why did the DB go suspect) and how did you fix it?
I suggest you do some checks (or get your sysadmin to)...
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
February 14, 2011 at 1:38 am
No. There's resource governor, but it just controls query memory and cpu, not the buffer pool.
If it's important, install separate instances and configure memory and CPU for them
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
February 14, 2011 at 1:27 am
I wouldn't be worried about the backup right about how, I'd be worried about the database itself. That error is on the mdf file.
Please run this and post the full...
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
February 14, 2011 at 1:25 am
As far as I'm aware, all indexable data types can be used as primary keys. Some just make less sense than others.
Can you clarify the question maybe? I don't think...
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
February 14, 2011 at 1:19 am
Jeff Moden (2/13/2011)
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
February 14, 2011 at 1:10 am
srikant maurya (2/14/2011)
Try to access the table same order in each procedure and use NOLOCK hint to avoid the sahred lock(while access the table ). It may help some exetend
It...
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
February 14, 2011 at 1:08 am
I'm sure the interviewer was looking for the previous answer, but in reality the solution would start with evaluating why the query is not using the index that is apparently...
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
February 13, 2011 at 10:42 pm
They can be, but it's the same principal. Store the results in a temp table for further processing. Nothing much fancier than that.
CREATE TABLE #StoredProcOutput (
<definition>
);
INSERT INTO #StoredProcOutput
EXEC SomeStoredProcedure
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
February 13, 2011 at 10:34 pm
What are you looking for?
The principal is the same, find the offending code and fix it. The two links should help you with the first, Grant's book with the second.
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
February 13, 2011 at 10:33 pm
My preferences are No_Infomsgs and all_errormsgs. No need to see all those x rows in y pages messages and, if there are errors, you don't want to be limited to...
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
February 13, 2011 at 10:32 pm
File IO and file system operations are not T-SQL's strong points. I would suggest doing them in a front end language, or at least something like SSIS. T-SQL is pretty...
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
February 13, 2011 at 2:09 pm
george sibbald (2/12/2011)
I have probably done it myself without realising it in the distant past, most likely to Gail 🙂
Nah, you and I tend to post within seconds of each...
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
February 12, 2011 at 3:54 pm
Anna_SQL (2/12/2011)
For now, could you tell me what usually is the best practice to run dbcc checkdb? every day, off hour or others?
It depends (like many things in SQL)
How large...
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
February 12, 2011 at 3:38 pm
Viewing 15 posts - 27,796 through 27,810 (of 49,552 total)