Viewing 15 posts - 34,951 through 34,965 (of 49,552 total)
sanketahir1985 (1/6/2010)[hrif i put .ndf file to new filegrp & restricts .mdf file then what will happen?
new data will go in .ndf or new .ndf file will be created?
Neither. 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
January 6, 2010 at 2:36 am
John Rowan (1/5/2010)
Keep in mind that hints are just that, hints.
CirquedeSQLeil (1/5/2010)
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
January 6, 2010 at 2:23 am
The answer's simple. The deadlock is against the Demand table, and the subqueries that query against demand do not have the nolock hint.
I would not suggest you add it. I...
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
January 6, 2010 at 2:20 am
Jen-574053 (1/6/2010)
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
January 6, 2010 at 2:18 am
Not all the women in IT initiatives are useful. There's a group in my area that I refuse to support and I will not attend their meetings. Why? Both group...
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
January 6, 2010 at 2:11 am
BSavoie (1/5/2010)
Is the "Available Free Space" figure on the "Shrink Files" dialog box accurate? Is that the amount I can expect to get back?
Pretty much, yes. If this was upgraded...
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
January 6, 2010 at 2:06 am
sanketahir1985 (1/5/2010)
2. After that if i create new .ndf file on new drive location, will sql server manage to put new data into .ndf file.
If you create it as...
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
January 6, 2010 at 1:55 am
Mark Chimes (1/5/2010)
Phil Factor (1/5/2010)
Some estimates describe an alarming percentage fall from 40% to 20%. Clearly something must be done to reverse the trend.</A>[/B]Why?
If there previously were 40%...
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
January 6, 2010 at 1:55 am
Why are there so many 'if you don't help me I'll lose my job' posts all over the place? I just got one by PM. Frankly, seeing that in 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
January 6, 2010 at 1:45 am
You can add table locks if you like, if you don't mind forcing SQL to run only one thing at a time. It's not a good thing for concurrency and...
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
January 6, 2010 at 1:37 am
badkow (1/5/2010)
The indexes are pretty normal.
I'm sure they are, but saying that the indexes are normal does not in any way help me to tell is they are useful indexes,...
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
January 6, 2010 at 1:31 am
Quinn-793124 (1/5/2010)
We do back ups every night.
Didn't ask about full backups. They do not truncate the log
How do you make a log file back up?
Look up BACKUP LOG in the...
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
January 5, 2010 at 3:45 pm
Since this is SQL 2005, what's the value of log_reuse_wait_desc in sys.databases?
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
January 5, 2010 at 3:38 pm
Can you post the table definitions and the actual definitions of all of the indexes?
Both that select and the update are part of larger procedures. Can you post the definitions...
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
January 5, 2010 at 3:15 pm
How often are you doing log backups?
Please read through this - Managing Transaction Logs[/url]
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
January 5, 2010 at 3:13 pm
Viewing 15 posts - 34,951 through 34,965 (of 49,552 total)