Viewing 15 posts - 33,601 through 33,615 (of 39,736 total)
What's the delimeter?
You can always add a value at the end of your view
SELECT DISTINCT
...
November 17, 2005 at 7:39 am
I don't think there's an easy way to do this in T-SQL. Not sure there's a great way. I typically definite defaults and then assign them, that way they can...
November 17, 2005 at 7:38 am
Quite a few of the backup scripts in the script library on this site do this.
November 17, 2005 at 7:37 am
You need to open ports on the DMZ firewall. Not sure what they are for 6.5, but your firewall people should be able to log attempts from the db server...
November 16, 2005 at 10:41 am
if exists( select top 1 * from table)
will return true if there is data.
November 16, 2005 at 10:41 am
Agree with that. Management often doesn't know who is qualified and who isn't. Heck, in many companies the DBA is alone and no one is qualified to interview them!!!!
November 15, 2005 at 2:34 pm
Here's my list. I have to say that #7 is new from when I first did this about 8 years ago. These aren't in any particular order.
November 11, 2005 at 10:40 am
Interesting thoughts. I'd argue, however, that if Reagan wasn't here or Mao or some of the others, that some other politician might have done made the impact.
There were lots of...
November 11, 2005 at 7:44 am
What client is this? Are you using ODBC, OLEDB? Something else?
When does this occur?
November 9, 2005 at 8:47 am
Maybe stop should not have been included because you could be stopping the SQL Server, but allowing the OS to run. To me it has always referred to quieting activity...
November 4, 2005 at 10:59 am
Used to be a German car guy, I've owned a couple VWs, a Mercedes, and now a Porsche 914. Still want a Thing and am looking
November 2, 2005 at 11:34 am
First of all move the PK.
Then, Protegrity has a fairly seemless system, albeit $$$ (http://www.protegrity.com/)
Netlib has something as well: http://www.netlib.com/sql-server-encryption.shtml
November 2, 2005 at 9:21 am
Once you jump to PAE, there is a need to get lots of RAM for the OS to switch in and out of. I thought that at 8GB, you needed...
November 2, 2005 at 9:19 am
Well done!?!?!!
Might as well eat charcoal.
Slap it on the rear and singe it with a brand on the way through the kitchen, please.
November 2, 2005 at 8:44 am
Apologies. The editor for the question keeps changing the brackets back from the HTML code so it kept moving my changes. I missed the close slash at some point because...
November 2, 2005 at 8:41 am
Viewing 15 posts - 33,601 through 33,615 (of 39,736 total)