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...
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)
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...
January 6, 2010 at 2:20 am
Jen-574053 (1/6/2010)
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...
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...
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...
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%...
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...
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...
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,...
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...
January 5, 2010 at 3:45 pm
Since this is SQL 2005, what's the value of log_reuse_wait_desc in sys.databases?
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...
January 5, 2010 at 3:15 pm
January 5, 2010 at 3:13 pm
Viewing 15 posts - 34,951 through 34,965 (of 49,552 total)