Very limited information for any one to answer.

Please submit your DBCC checkdb output and the complete error log of the backup.

What ever is deleted will be show as the output.

After the delete statement.

Please use

select * from @t

Just to see what are the records that are deleted. The...

This sql statment deletes X records and those records deleted were show in the result window. Other than that this is a pretty straight forward self join delete statement.

select...

The code seems to be good. This will insert all the serials which are not in target database.

Unless if your serial column is not the primary key in both...

Looks like home work question.

select 'Alter table ' + s.name + '.' + T.name +' Add Name varchar(5)' from sys.tables T Inner join sys.schemas S...

This is a very open ended question.

You need to identity the pattern of the blocking.

Meaning the timing, process, db design, memory etc etc. To start with use service...

Missed printing the number of items for pens and pencils.

Updated one.

Create table #PenPencil (Pen int, Pencil int)

go

Insert into #PenPencil

select 4,2

union

select 5,6

union

select 1,0

union

select 0,3

select

Case...

Home work question

🙂

Create table #PenPencil (Pen int, Pencil int)

go

Insert into #PenPencil

select 4,2

union

select 5,6

union

select 1,0

union

select 0,3

select

Case when Pen > 0 then 'Pens'

When Pen...

I need my points The second will return 1 only.

Thank you everyone for the suggestion, is there any method from SQLserver to extract the file steam object. Since this a production environment, executing the codes may be bit challenging....

Purging helps you to reclaim free space in the database. If you are expecting the free space in the OS level you need to do db shrinking. And DB shrinking...

The other approach will be change the default database name from Master to the database name that you use for the login.

EXEC sp_defaultdb 'Victoria', 'AdventureWorks2008R2'

This makes when ever the...

Please go through this article this is good.

http://blogs.msdn.com/b/john_daskalakis/archive/2009/04/22/9562252.aspx

Please identity the area where it can slow down

1) How long does the complex select takes to produce the result.

2) check the tables involved in the complex select.

3)...

It is very simple, go to SMS press F2 to rename and change to your desired name.

Sorry my bad i did not go through the full question.