Viewing 15 posts - 1,936 through 1,950 (of 2,496 total)
The advice I have had from PSS is never set the max and min memory the same, as this disables some of SQL's memory cleanup processes. Even if you...
October 12, 2007 at 3:05 am
Download the linked research paper, as it covers your situation. In a few words, it is saying any file under 256 KB is handeled more efficiently in SQL than...
October 12, 2007 at 2:55 am
Just to add a bit to Rudy's reply... You need to avoid Dynamic disks in any situation where the disks are put offline and online. This is because...
October 11, 2007 at 4:56 am
Are you doing log backups, or just full backups?
A full backup takes a copy of the data (.mdf) file, and that portion of the log that was used while the...
October 11, 2007 at 4:45 am
One other thing to remember. You are running 32-bit code, which means all your user connection memory has to live within 2GB, along with all other SQL memory apart...
October 11, 2007 at 4:34 am
To me it looks like Nikki has more problems than a newcomer to terabyte-sized databases and a newcomer to the business can solve.
The best advise I can give is to...
October 11, 2007 at 4:27 am
One of the biggest problems with SANs is that the DBA and Storage Admin people hardley ever talk to each other, and often company politics prevents them talking to each...
October 10, 2007 at 9:57 am
SUN SANs typically inherit the way Storage Tek did things before Sun bought STK.
This means you typically get dynamic provisioning for your data. With dp, if you define a...
October 10, 2007 at 3:03 am
If your query is executed on a multi-processor machine, then SQL may choose to open multiple threads to return your result set. If the DBA has defined multiple files...
October 8, 2007 at 5:50 am
I am also a generalist, who happens to know a bit more about databases than other subjects. I started out on mainframe, did some work on OS install and...
October 8, 2007 at 5:39 am
If you are just moving the log file, do an ALTER DATABASE xxx ADD FILE to get a new log file wher you want it. You then need to...
October 4, 2007 at 3:07 am
This sounds ilke the KB 917406 problem. Even though our sitation did not meet the criteria listed in KB 917406, we got the message quoted, and applying the workaround...
October 4, 2007 at 2:51 am
If you need to add a component to an existing SQL Server 2005 installation, you need to use Windows Control Panel, Add/Remove Programs, and click on SQL Server 2005. ...
October 4, 2007 at 2:45 am
Ask Google to find code that gives the original text for an 'encrypted' stored procedure. SQL Server uses obfuscation to hide the text of a stored procedure, not encryption....
September 28, 2007 at 3:18 am
Does your organisation use an accounts package? This type of thing should be covered by the package.
There are significant business risks in organisations writing their own accounts systems. ...
September 28, 2007 at 3:14 am
Viewing 15 posts - 1,936 through 1,950 (of 2,496 total)