Viewing 15 posts - 30,106 through 30,120 (of 39,763 total)
I've seen some consultants recommend 28-29GB if this is only a SQL Server box. You need to run some metrics and be sure that it won't cause issues. 64-bit should...
December 26, 2007 at 9:42 pm
It depends on how you set things up. Some people have used IPs instead of the server name. IF it's by servername, it should be ok, SQL should start...
December 26, 2007 at 9:41 pm
What about returning the four columns and running 4 queries looking for exact matches on one column each, then unioning them. You could list the results in some order and...
December 26, 2007 at 9:38 pm
There's no way to know this. You could guess, but even the optimizer doesn't know how long. It can guess, but it's just that.
December 26, 2007 at 9:36 pm
While I agree with Jeff that you might want to trust the DBA, I know that some of my sysadmins were much better at tuning Windows than me and...
December 26, 2007 at 9:35 pm
While I don't like SELECT * in code, I'm not sure it's less efficient. I'd like to know why. I always learned that it resolved the column list at compile...
December 26, 2007 at 9:31 pm
Optimum is hard to determine. It's somewhat a philosophical debate on how you want to handle things.
Personally I don't like linked servers. Possible security holes could be used for other...
December 26, 2007 at 9:28 pm
I was thinking that the compression could aid the solar hot water in providing radiant heat. The cold air could be used for cooling in the summer.
I still agree the...
December 26, 2007 at 9:22 pm
Hadn't thought about that, but it would be nice if you could use that thermal energy somehow. Maybe incorporate into some heating/cooling application?
December 26, 2007 at 12:55 pm
Please don't cross post. We check all forums.
December 26, 2007 at 10:50 am
Yes, partitioning can easy keep data separated, usually by dates, but could be by other values, and let you add rows to "part" of the table without affecting the other...
December 26, 2007 at 10:50 am
Haven't really noticed this, but I haven't messed with the system tables much. Does the login have SA rights? Are there any problems?
My guess is that it's a display issue...
December 26, 2007 at 10:40 am
If the old and new are on the same server, the backup and restore will be easy. I'd recommend you do an EXECUTE AS (look up), to allow people with...
December 26, 2007 at 10:39 am
I wish, but no. The threading models are vastly different and Microsoft has declined to rewrite it for a *Nix.
You can run Windows under VMWare or another virtualization technology...
December 26, 2007 at 10:32 am
Viewing 15 posts - 30,106 through 30,120 (of 39,763 total)