Viewing 15 posts - 36,571 through 36,585 (of 39,771 total)
ANSI standard. and habit. Helps to clarify for me. You can drop it if you wish.
Steve Jones
February 12, 2003 at 11:36 am
I think you might need to escape the single quote. Try a replace('''', '''''') around the @idoc.
Steve Jones
February 12, 2003 at 11:34 am
Agree with the last post on that one. Better to setup a backup job. depending on AutoClose isn't a reliable option.
Steve Jones
February 10, 2003 at 9:47 am
dual doesn't work in SQL Server.
select 'pick a schema', ''
union
select col1, col2 from my_table
Steve Jones
February 7, 2003 at 3:03 pm
Never used the $99 option. In my last job, I used the $250 option, one was a bug, no charge, one was help fixing corruption.
At this job, we're a Premier...
February 7, 2003 at 3:01 pm
I think this will cause an issue. Can you not take a full backup and move that over after the new file?
Steve Jones
February 7, 2003 at 9:38 am
If they rarely change, I'd put them in each db and then use an app, script, or possible replication to update them.
If they change often, I'd probably use a master...
February 7, 2003 at 9:31 am
Probably that's it. Covers two drives failing before the spare gets going.
If you get it for no $$, might as well. Buy 5-8 drives for your main array, 2 more...
February 6, 2003 at 5:46 pm
Still won't protect the code from someone getting to it. Anything can be decompiled.
Steve Jones
February 6, 2003 at 5:42 pm
not sure what you mean? are you replying to the article or a post?
Steve Jones
February 6, 2003 at 5:39 pm
And intellisense!!!!!
Send suggestions to sqlwish@microsoft.com
Steve Jones
February 6, 2003 at 2:14 pm
Depends on the performance. I'd simulate the 10M rows and see, but my thought is one table/month. If the db performance is too low, separate DBs or even filegroups can...
February 6, 2003 at 2:03 pm
Like Raid 5 +.
Here's the FAQ:http://h18004.www1.hp.com/products/servers/proliantstorage/arraycontrollers/adg/questionanswer.html
Looks like the space usage for parity is 2 drives and is worth it above 5 drives. Basically appears to be items.
1. Allows 2 drives...
February 6, 2003 at 2:00 pm
Viewing 15 posts - 36,571 through 36,585 (of 39,771 total)