I'll look into seeing if it can become part of a covering index, that sounds like the better plan. Best Regards
I've been looking at the following query: SELECT CONVERT (varchar, @runtime, 126) AS Runtime , CONVERT (decimal (28,1),...
Config info: 4CPU (quad core) SQL 2005 SP3 32GB RAM Max Degree of Parallelism set to 8 OS Windows 2003 sp2 on a RAID 1, RAID 10 log files, DAS unit...
The two largest databases (40GB & 73GB) will probably grow by 5-10% over the next year. After that we will be removing old data which should keep...
There would be 5 databases, ranging in size from 74GB - 5MB Total db size. Data:33601mb Log: 127445mb Number of users would be at most about 20 users...
I have a DELL R905 w/2-quad core cpu's, 32GB RAM, Windows 2003 x64, SQL 2005 x64 and would like to know about the drive configuration. Right now I...
I have been battling what I believe is a memory issue and I have been trying to figure out why the page life expectancy on this server is all over...
It's always simple once somebody shows you how. Some day I want to be as good as you guys [grin]. Many mamy thanks, Mike
I see what your saying but the number of values being returned might vary, how am I to know how many commas I must use (concatenate) in the string or...
I believe I have the syntax correct my string when I print the @StringSQL looks like this: declare @List varchar(8000) Set @List = '005512''' +...
Thanks, and yes the list will come from user input at the front end and get passed to the proc. The expression should look like: IN...
I'm trying to create a proc (SQL 2000) that takes a single input paramter from a front Cold Fusion app. The parameter should hold a comma delimited...
Separate names with a comma.
