Guras (3/12/2012)

---

The database size of one of our databases is 75GB ( though it still has 30G more free space) and it is growing fast. I am looking into shrinking...

As a developer you are more likely to work a consistent 40 hour work week. Of course that doesn't mean a developer won't put in OT to get a...

I would probably separate the Category and Subcatergory tables. Only data related to Category would be in the Category table and only data related to Subcategory would be in...

capn.hector (3/12/2012)

---

you can try setting it to single user mode. then after you restore alter the database back to multi-user mode. is should work and will kill any...

From BOL:

C. Using the ESCAPE clause

The following example uses the ESCAPE clause and the escape character to find the exact character string 10-15% in column c1 of the mytbl2 table.

USE...

Would still like to know who this "they" is.

Look up identity columns in Books Online.

dilakshan31 (3/12/2012)

---

Ok they have asked us to create a database which I have and now I need to create a table. They ask for event I'd to be unique and...

If tempdb is on an SSD drive, why would you want to move it to ram?

Please read the first article I reference in my signature block below regarding asking for help. Follow the instructions on what and how to post the information we need...

Looks like you are on your way to being an "Accidental DBA." If these databases aren't too big, you may want to consider using maintenance plans at this point....

Using the case, you could eliminate the CTE as it may not be needed. It would help, of course, if we actually knew what you were trying to accomplish instead...

How about something along these lines:

create table dbo.test1 (

tid int identity(1,1) not null,

ldate varchar(8) not null);

insert into dbo.test1 (ldate)

select '11/02/10' union all...

Not what was requested.

Please read the first article I reference in my signature block regarding asking for help. Follow the instructions in that article regarding what and how to...

David Gugick (3/11/2012)

---

LiteSpeed includes built-in support for Log Shipping. So, if you'd like to use LiteSpeed, you absolutely can. If you'd prefer to use native, then you would have to...

BCP, check it out in Books Online.