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...
SQL DBA.
December 1, 2010 at 1:34 pm
More explanation on COALESCE expression error..
SQL DBA.
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...
SQL DBA.
November 9, 2010 at 8:25 am
Create Table #Test (a int, b int, C as a+b )
go
insert into #test values (3,4)
insert into #test values (1,7)
go
select * from #test
order by 1
go
drop table #test
go
Isn't it funny that...
SQL DBA.
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...
SQL DBA.
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,...
SQL DBA.
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?
SQL DBA.
October 5, 2010 at 8:20 am
Easy one. With Begin and Rollback Transaction included in question it's easy to select correct answer.
SQL DBA.
September 29, 2010 at 8:17 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...
SQL DBA.
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...
SQL DBA.
September 23, 2010 at 7:21 am
stevefromOZ (9/13/2010)
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....
SQL DBA.
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...
SQL DBA.
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...
SQL DBA.
September 10, 2010 at 7:52 am
C# is ok but F# ? It's a wrong choice written all over it.
SQL DBA.
September 7, 2010 at 8:15 am
Viewing 15 posts - 16 through 30 (of 446 total)