Viewing 15 posts - 16,366 through 16,380 (of 39,970 total)
It's a fairly arbitrary concept and with conflicting information on the calculations, it's hard to understand what is correct. The way that it's given in the white paper, which is...
April 28, 2011 at 8:35 am
The schema affects query performance only in terms of how many joins you might need to perform queries, but any balancing out to reduce query time can increase resources to...
April 27, 2011 at 9:24 pm
You have the logic there, just work through it.
First, check nickname. It it is null, then what? It looks like you are going a little too quickly with the logic....
April 27, 2011 at 9:17 pm
Thiago is correct. I would do
Raid 1 - OS and backups
RAID 10 - tempdb, system dbs, data files
RAID 1 - log files
How many drives do you have?
April 27, 2011 at 9:11 pm
Do not count on the index rebuild to fix this. As mentioned, an ORDER BY is required.
If anything was "working" before, it was coincidence, not causality. You could get the...
April 27, 2011 at 4:51 pm
Please explain what the issue is and show all the code. You must tell us what you think should happen and what is not happening. From the code, there is...
April 27, 2011 at 4:47 pm
stick tempdb and the systemdbs with the data files on R10. You likely won't get a huge benefit from separating them, and I'd combine them first.
Make sure you drop backups...
April 27, 2011 at 3:47 pm
Filegroups are about manageability and recoverability (enterprise has partial database availability). The file stack drivers don't perform better with more files. You aren't getting any parallelism there. Most databases have...
April 27, 2011 at 1:25 pm
Gentlemen,
You are welcome to debate this and it is interesting, but please keep it professional and agree to disagree about things that you cannot resolve. Please do not call each...
April 27, 2011 at 1:16 pm
GilaMonster (4/27/2011)
April 27, 2011 at 10:58 am
Stefan Krzywicki (4/27/2011)
April 27, 2011 at 10:57 am
I may be wrong, and I'll admit that. However the "use" of the data in terms of when/how you might call someone is debatable. The data domain itself is a...
April 27, 2011 at 10:53 am
You don't need separate files for each partition. I'd create a separate filegroup for the archive, RAID 50 data and move the partitions there.
Your decision to compress things is sound,...
April 27, 2011 at 10:48 am
I might ask if you really need to run SSMS as an administrator constantly? If it's to connect as an admin to the SQL Servers, then I'd change the...
April 27, 2011 at 10:46 am
Stefan Krzywicki (4/27/2011)
That mindset is unlikely to go anywhere. Many managers know that if they're not keeping an eye on the workers, they have nothing to offer the company.
I'm not...
April 27, 2011 at 10:14 am
Viewing 15 posts - 16,366 through 16,380 (of 39,970 total)