Viewing 15 posts - 27,181 through 27,195 (of 39,793 total)
1. order in the WHERE clause does not matter.
2. What's the dat? This doesn't make sense in SQL Server.
3. Not sure, might depend on the isolation levels set on the...
September 8, 2008 at 11:24 am
Haven't tried it, but this might help you: http://www.sqlservercentral.com/scripts/Miscellaneous/31062/
September 8, 2008 at 11:22 am
I'd suggest you do some reading at the SQLCat team's site at: http://sqlcat.com/. They do a lot of work with large installations and you could get some data there.
As far...
September 8, 2008 at 11:22 am
You can capture the new database using a DDL trigger or an event notification. If you store that data off in some table, then you can track it. You can...
September 8, 2008 at 8:44 am
You could compress them, but you'd need to either Sp_OACREATE to grab an object handle to some zip utility or shell out (xp_cmdshell) to do the command line call.
You might...
September 8, 2008 at 7:49 am
You could always start one :w00t:
September 8, 2008 at 7:32 am
You have to try and collaborate, try and help, but at the same time you have to meet your responsibilities.
Management has to see this, perhaps by dividing responsibilities and letting...
September 8, 2008 at 7:31 am
I have friends who think that outtakes are the editorials!
You and my kids like those the best.:hehe:
September 8, 2008 at 7:26 am
I'd argue that having command line options is a part of usability. Just like every program I wrote years ago had to respond to "/?" from the command line, just...
September 8, 2008 at 6:56 am
Not sure about the Java driver, but that typically is a communication/network type error.
September 6, 2008 at 8:17 pm
3.24GB of RAM? Is this a 3GB or 4GB machine?
There are no real configuration settings that you need to change. However it completely depends on what you are doing with...
September 6, 2008 at 8:16 pm
It's not that I don't want to go uphill, but there doesn't seem to be much uphill and close to the convention center. Much more if you head down towards...
September 6, 2008 at 8:15 pm
Users have no rights to tables unless they are granted. If they are granted as part of a role or rights, then you can use DENY as listed above.
September 6, 2008 at 8:13 pm
Viewing 15 posts - 27,181 through 27,195 (of 39,793 total)