Viewing 15 posts - 16 through 30 (of 446 total)
I am bad at writing articles but the easiest I think is to add a step next to backup command in job schedule. Add this command to next step...
December 1, 2010 at 1:34 pm
More explanation on COALESCE expression error..
November 12, 2010 at 7:20 am
Hugo Kornelis (11/9/2010)
I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually...
November 9, 2010 at 8:25 am
Create Table #Test (a int, b int, C as a+b )
insert into #test values (3,4)
insert into #test values (1,7)
select * from #test
order by 1
drop table #test
Isn't it funny that...
November 8, 2010 at 8:34 am
XML always remained mystery to me. Never understood the concept completely. May because I never worked on a project which had mandatory XML programming.
And just last week got...
October 26, 2010 at 8:02 am
For the same reason I never use sp_rename to rename object in sql server.
Always prefer if exist method.
if exists (select * from sys.objects where object_id = object_id(N'[dbo].[Object_name]') and OBJECTPROPERTY(object_id,...
October 7, 2010 at 10:03 am
Why do this task with VB script when you can do the whole process with T-SQL scripts?
October 5, 2010 at 8:20 am
Easy one. With Begin and Rollback Transaction included in question it's easy to select correct answer.
September 29, 2010 at 8:17 am
Glad it worked.
September 28, 2010 at 11:29 am
I had the same issue some time back and had to spent more than three days to know the cause.
First thing first change the data type to Nvarchar in the...
September 27, 2010 at 1:25 pm
looking at the options, I thought option one would be the right answer. Since both inner and outer rollback, query would return zero rows.
then executed it and got right...
September 23, 2010 at 7:21 am
can i take back my article rating somehow?
Steve, it's a pure form of plagiarism. But, why take the rating out for article. It's a well written article....
September 13, 2010 at 8:14 am
Nice article. But, for Omeshwar, Nice hard work of CTRL + A, CTRL + C and CTRL + V.
Nothing wrong in taking knowledge / Points from others, but there...
September 13, 2010 at 7:26 am
Good question. I had not disabled index as of now or never tried. Thought that it would fetch data but would take time, period.
But, never knew that disabling...
September 10, 2010 at 7:52 am
C# is ok but F# ? It's a wrong choice written all over it.
September 7, 2010 at 8:15 am