if your table is a HEAP, the space would not be released automatically.

to release the space, I guess you can create a clustered index, which will re-organise all the...

Hi,

We were earlier using LogShipping and then moved to mirroring and snapshots. We were running LogShipping on an hourly basis during the day, and disabling it during the night, so...

What happens when you query the table with where Ltrim(Rtrim(lastname)) = 'Smith' and Ltrim(Rtrim(Firstname)) = 'Robert'?

pankushmehta (8/31/2010)

---

If your database is in full recovery mode, you can backup the Transaction log and then shrink the file.

If your database is in simple recovery mode, you can just...

You can query sys.dm_tran_locks or sp_lock, which can show you if there are any locks being held.

Also check if there are any open trans which have not yet been comitted...

SQL users are mapped via SIDs which are varbinary. to have the same sid in 2 different servers for same login name is unlikely. Therefore, when you move the databases,...

This can cause you grief, as simply copying data will not copy defaults, constraints, keys etc that are defined on the tables.

As GilaMonster rightly pointed, the easiest way is to...

If your database is in full recovery mode, you can backup the Transaction log and then shrink the file.

If your database is in simple recovery mode, you can just shrink...

JC-3113 (8/31/2010)

---

sorry

had an extra comma after program_name:

select

a.dbid,

CAST (b.name as varchar(90)) as database_name,

CAST (a.loginame as varchar(36)) as loginame,

CAST (a.hostname as varchar(18)) as hostname,

cpu,

a.login_time,

CAST (a.status as varchar(18)) as status,

CAST (a.program_name as varchar(50))...

You can use IF Exists to check if the job has ever run before. if the job has never run, there would be no entry in the sysjobhistory table....

Can you please provide a bit more of details. I am not sure if I understand it correctly.

You can create a windows group (or AD group) and grant it read permission to all the databases. All you...

You should start with sys.dm_db_missing_index_details. This can possibly provide you with some information to begin with.

You can also use SQL Profiler to capture the queries and from there find out...

If you export the data, you do not really export the metadata. you need you take note of the constraints, indexes, defaults etc.

If you can afford it have both!

Clustering for high availability and mirroring for reporting 🙂