Paul White NZ (10/2/2010)

---

Local news: Lots of changes on 1 October. GST went up, income tax came down, and Internet bandwidth increased to 15Mbps from 10Mbps. And I'm...

Log shipping can only be used against a database that has Full or Bulk-logged recovery. The recovery model for most of the system databases is Simple (see BOL - Recovery...

Not exactly what you are looking for, but the following code can be used as a starting point.

I came across this code in SSC some time ago - it shows...

Vasudev Tantry (9/9/2010)

---

I have designed a view as below,

SELECT dbo.cardholder.c_fname AS [First Name], dbo.cardholder.c_lname AS [Last Name], dbo.cardholder.c_nick_name AS [Emp Id],

...

Apparently tomorrow will be the 65th anniversary of the first computer bug:

http://www.history.navy.mil/photos/images/h96000/h96566kc.htm

From that point on all developers had a job for life.

THE-FHA (9/7/2010)

---

Clearly the person who asked knows what he wants. please help.

I need the Syntax.

Lets say i want to set isolation for read commited snapshot ON. how do i go...

I rarely rate a subject, but this one deserves it in my opinion, in order to draw people's attention to it. I think everyone should know how SQL Injection works...

If you're referring to the Isolation Levels for SQL...

Was August the month for SHRINKDATABASE and SHRINKFILE? The forums appeared to have these through them like a stick of sea-side rock for the past month.

I'm surprised Gail's link about...

My wife is suddenly more interested in our flight out there in February and wants to know...

vamshi.sql (8/23/2010)

---

Hi Everyone,

Can any one clarify what will happen when we execute the below query..

USE DatabaseName

GO

DBCC SHRINKFILE(<TransactionLogName>, 1)

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(<TransactionLogName>, 1)

GO

Is there any possibilities to loss some...

Lowell, a better explanation than I was trying to put together.

Where I work now its 'CAST(CONVERT' everywhere where a date comparison is required. It's a pet project of mine to...

GetDate also returns the time, would that be the cause of your problem?

The people that have asked you to do this are going to have to understand that in your situation you'll need time to learn and practice these things.

A description of...

Webmaster, I did you a disservice - I assumed you were one of...