Hi. One of my databases has an assembly that uses system.web. Therefore, in the deploy script, the developer has put in a create assembly for it...
Windows 2003 EE & SQL 2000 EE. 6Gb RAM - 5Gb AWE allocated to SQL. Quad core - 3 core dedicated to SQL. Situation is that I'm getting regular but...
SS2KEE on W2K3EE. If 32 bit SQL can only address a 4Gb virtual address space, does that mean it's pointless setting the amout of RAM for it to use...
First off, how much space is allocated to this by default on SS2KEE? I've seen stuff on the net that that says 256Mb, 384Mb and BOL says 128Mb. How...
Okay folks. Tough one (maybe) I'm monitoring a production server, and I see a cached query plan for a select statement - which doesn't have a where...
I have a plan in procedure cache that has a high usage count. It is a select of some columns without a where clause. There are other plans that are...
Are all SQL server i/o's 8k? Tradeco wholesalers, drop shippers & trade network
Can anyone shed any light on how to interpret this column? Tradeco wholesalers, drop shippers & trade network
What's an acceptable level of paging for operating system (in this case 2003EE)? Tradeco wholesalers, drop shippers & trade network
New server has 6Gb phyiscal RAM. What's the optimal split between OS and SQL of this amount of RAM? Thanks Tradeco wholesalers, drop shippers &...
Want to check my thinking with you folks... I have a table with a clustered composite index, consisting of 3 columns, which together form a unique...
Hi, have got a stored proc that currently creates a string by concatentating info and the running it using xp_cmdshell @cmd. This sparked off...
Separate names with a comma.
