Jan Sorenson (10/19/2012)

---

Is it possible to grant access to specific columns in a table with restriction to the data with a where clause? Similar to building a view but...

I'm currently living in an ORM DBA nightmare. Pulling data for reporting requires an inordinate amount of complex code. Maintenance is hell. I really wish the developers had consulted a...

Michael Rybicki (10/17/2012)

---

I love that command but for the life of me I can not figure out why it fails if you try to use it to set your RECOVERY...

1. Why have date and amount in seperate tables?

2. If paymentId is unique it is possibly a good candidate for a primary key, especially if it is ascending.

3. Is paymentId...

Steve Malley (10/17/2012)

---

Since I am only accessing the system catalog and a DMV, I would expect that performance should be consistent and fast. I find that it is not. It...

http://www.sqlservercentral.com/articles/books/76296/

The OP cannot sort the result set using varchar, hence the bigint.

Bhuvnesh (10/17/2012)

---

YOu have to tuse something like this

Where Col1 = @v1 OR Col2...

CREATE PROCEDURE addDocDetail

@detailID int = NULL,

...,

...

AS

SELECT @detailID = ISNULL(@detailID, IDENT_CURRENT('Doctor'))

...

...

GO

You can find this in the job history table.

SELECT j.name,

jh.run_date,

jh.run_time,

SUBSTRING(jh.message, CHARINDEX('.', jh.message) + 3, CHARINDEX('.', jh.message, CHARINDEX('.', jh.message) + 1) - CHARINDEX('.', jh.message) - 3) AS MiddleMessage

FROM ...

Test, test, test

http://sqlserverconsulting.blogspot.com/2009/12/thinking-in-sets.html

http://www.amazon.com/Joe-Celkos-Thinking-Sets-Management/dp/0123741378

Firstly, it should be GIS.dbo.GISDaily and not dbo.GIS.GISDaily.

Secondly you can leave the database in simple recovery.

USE DBT;

GO

IF OBJECT_ID('GIS.dbo.GISDaily', 'U') IS NOT NULL

DROP TABLE GIS.dbo.GISDaily;

GO

SELECT *

INTO GIS.dbo.GISDaily

FROM GIS_Info

GO

Here is an excellent blog explaining the issue:

http://www.sqlskills.com/blogs/paul/post/Why-LOB-data-make-shrink-run-slooooowly-(T-SQL-Tuesday-006).aspx

And Paul Randal's Shrink Alternative:

So what if you *do* need to run a shrink? For instance, if you've deleted a large proportion of...

Of course the order matters.

Picture a phone book. The index column order is Last Name, First Name.

Now if I asked you to find everyone who's last name is 'Smith' you...