Bhuvnesh (1/11/2013)

NO , NUll is...

You have to remember that NULL in SQL means two things:

1. Empty set

2. Undefined set.

This is an well know set algebra bug in SQL.

11 lakh is over the ~1 million limit of excel.

Looks like you are out of luck.

What Gail said.

Stored procs are like an API to the database.

You have to identify the use cases for the database interactions and then define the stored proc interfaces (input/output params...

I am aware of that.

However you can deduce who is doing what based on the entries in the default trace.

If you have default trace records from around the time of the delete, you may be able to compile a list of suspects. Hopefully you do not too may...

The dead lock might be caused by backup history cleanup process.

The default proc is slow and causes a lot of locking.

Is a database being dropped with delete of backup history...

Below is code I use to get info on processes that are blocking and blocked:

SELECT DISTINCT

sysdatabases.name as database_name,

blocked.spid as blocked_spid,

blocked.waittime/1000 as wait_seconds,

convert(varchar(80),blocked.loginame) as blocked_loginame,

blocked.cmd as blocked_command,

convert(varchar(80),blocked.program_name) as blocked_program_name,

blocked.lastwaittype,

convert(varchar(80),blocked.waitresource) as...

In general, certification mainly helps if you do not have a lot of experience. Once you have experience, people that are worth working for will focus on that.

Sample code:

declare

@max_backup_set_id int,

@db_name varchar(50)

select

...

Why are you not getting the file name and path from msdb?

Are you comfortable with the security issues related with using xp_cmdshell?

As a rule I don't like to run on 1433.

Yes, any scanning tool out there will try to attack 1433 first.

They will try to log in as sa and sometimes...

And is CPU high on the SQL server box?

Is there a particular reason your SQL server is not behind a firewall?

How many times a second are the errors?

High number of login attempts can chew up CPU, but it would have to be very frequent.

Generally, any SQL server instance running on...

This is a classic issue with the SQL Agent scheduler.

If a job does not fire due a time issue on the server, it will not run again unless you run...