Viewing 15 posts - 16 through 30 (of 38 total)
I wrongly assumed I didn't need additional setup for W2K3 and MSSQL Server 2000 32-bit. I still had to setup AWE as I have done before--especially using the max...
June 11, 2005 at 2:34 pm
I've noticed some clients that did not have any network protocols enabled but were still visible on the network. Since I typically enable protocols or disable them on install,...
June 11, 2005 at 2:30 pm
I wonder if you have the same issue as I have. My laptop stays wireless all day. I lose connection one or more times per hour and have...
June 9, 2005 at 4:02 pm
If you want to reduce overhead on doing traces, look into using server-side traces, without the Profiler GUI. These call the sp_trace_% extended stored procedures. Ken Henderson has...
June 9, 2005 at 12:45 pm
You can shell out with xp_cmdshell (right) and run something like WinZip's wzzip to compress and weak encrypt after the backup is done. It's fairly reliable. Use UNC...
June 4, 2005 at 3:34 pm
For boot.ini, go to My Computer, Manage or click on Properties, you'll find a tab where you can edit the start up. However, with W2K3, PAE should be enabled...
June 4, 2005 at 3:30 pm
From another post, I got the impression that since MSSQL Server can only update, insert, delete to one filegroup at a time on one thread / processor, that having another...
May 25, 2005 at 10:55 am
As far as SAN and fiber, keep in mind that 2 Gb (Gigabit)/second is equivalent to 200 MB MegaByte) / second. I just had that experience thinking that RAID...
May 23, 2005 at 11:47 am
Ken Henderson covers this in "The Guru's Guide to SQL Server Stored Procedures, XML, and HTML". I've considered it and can see the benefit of it. Hopefully, SQL...
May 22, 2005 at 12:32 pm
With RAID configurations, the primary benefit seems to be if one of the files becomes corrupt. Supposedly, if the index file becomes corrupt, if it's in a separate file,...
May 22, 2005 at 12:20 pm
I had one today like this one. For some unknown reason, if the user creates an alias to the server using the Client Network Utility on their machine, they...
April 12, 2005 at 2:48 pm
I've seen some minor latency with similar setups. If you're not or even if you're using the standard 1433 TCP/ 1434 UDP ports, you may want to go to...
November 4, 2004 at 12:34 pm
The answer is yes. After seeing the post on public role, I looked at the SELECT permissions that the public role had on systypes and syscolumns and they had...
November 3, 2004 at 4:22 pm
If you installed with Windows authentication, at the server, you should be able to get into Enterprise Manager and do that when logged in as Administrator. Installation gives the...
November 3, 2004 at 1:22 pm
.Net 2003 does not automatically install MSDE (local SQL). It points you to a link to download it and install. I recommend installing the NetSDK instance and not...
October 21, 2004 at 11:14 am
Viewing 15 posts - 16 through 30 (of 38 total)