Viewing 15 posts - 1 through 15 (of 359 total)
December 15, 2006 at 3:57 pm
I agree. I have been using DBCC commands in 2005 for months with few issues. That is an odd phrase.
This article, will ok, was not a best practices. It was...
January 4, 2006 at 7:46 am
Sad but true stories. We could sit around and talk for hours about the foolish. I think Sean is right - SQL Server has been advertised as easy and wizard-friendly....
September 19, 2005 at 4:48 pm
I agree with Remi - it is better to have a target list rather than a * - you know what you have.
April 8, 2005 at 1:11 pm
maybe we can meet outside and have some from this green stuff they used to drink in France. (You remember?!?)
Laughing. I do. I have not gathered up my courage to...
April 8, 2005 at 8:22 am
Congratulations Frank. Now you can go outside once in awhile and look at that bright thing in the sky.
April 8, 2005 at 7:29 am
Firefox just released version 1.0.1.
I have used it for about a year. There are some sites that require IE (everything shows up "off" in Firefox) but I would say...
March 4, 2005 at 10:13 am
Could you make this a stored procedure? Then you could run it with a EXEC command.
February 25, 2005 at 10:30 am
February 24, 2005 at 1:06 pm
[SQL Server Developer edition] includes all of the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment (for complete...
February 24, 2005 at 9:31 am
I could find nothing on standard to enterprise, but there were two articles on upgrading evaluation to retail - I assume the information is the same.
February 23, 2005 at 4:58 pm
Declare @evalue varchar(?)
SELECT @evalue = master..xp_repl_encrypt @number1 output
INSERT tblpassword (column name 1, column 2)
values ('IT', @evalue)
I know it is optional, but I always list the columns to be inserted.
February 21, 2005 at 2:06 pm
You will find the error handling in T-SQL to be, well, primitive. There is no function that returns the line number for an error. One reason may be that databases...
February 18, 2005 at 12:53 pm
What do you mean by implement? S-locks are assigned by SQL Server based on the query.
February 16, 2005 at 10:39 am
I have had most of the major certifications (meaning I like to take multiple choice tests). Do I plan to keep them updated? No. I do not (literally) have the...
February 15, 2005 at 2:23 pm