To convert an integer year number to the last day of the year, you can use DATEADD without the need to convert to a character string:

-- Convert year number to...

If you are using SQL Server 2008 R2 Enterprise Edition you can encrypt the whole database with transparent data encryption (TDE), and no changes at all are required to your...

Here is an example for the current year:

select LastDayOfYear = dateadd(yy,datediff(yy,-1,getdate()),-1)

Results:

LastDayOfYear

-----------------------

2012-12-31 00:00:00.000

(1 row(s) affected)

For a different year, just replace getdate() with a date in that year.

Since you are running Enterprise Edition, you should be able to drop the clustered index and create the new primary key clustered index using the ONLINE = ON option, if...

I don't give much credibility to anything I read on the InfoWorld site, even when they're quoting another source.

They're just cheerleaders for the latest IT fads, and shills for their...

GP Van Eron (6/29/2012)

---

Hi there,

Had interesting task today, to seach sps / views in a db for any containing '*' character.

So far I have tried the following...

I posted an answer to this on SQLTeam

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176259

It might help if you posted your actual query formatted is a way that people can read.

SELECT

MAX(EC.eecDateOfTermination)

FROM

EMPCOMP EC

WHERE

-- no table with an alias of E in this query

EC.EecEEID = E.EECEEID...

Are you sure this will really be a problem? Have you noticed any performance problems? How many rows will the table contain?

Is the fragmentation really on the clustered...

ScottPletcher (6/27/2012)

---

Eugene Elutin (6/27/2012)

---

Not for nested transactions, check this one:

begin transaction outerOne

update Table1 set Col1 = 'booo' where id =1...

nic79 (6/27/2012)

---

Ok I see what you mean, thanks guys! I am using 2008 so I could use datetime, but for my needs (working with an update on dummy databases) I...

Jeff Moden (6/26/2012)

---

nic79 (6/26/2012)

---

Jeff, that worked perfectly and much simpler than the way I was approaching it. I was able to run the update on the entire table using that...

D. Clark (6/26/2012)

---

Lynn Pettis (6/26/2012)

---

Maintenabce plans are good for small databases or when you find yourself an Accidental DBA having to get something into place. I used them when...

The data was probably there, but the query output in Management Studio can show a maximum of 8192 characters per line, and defaults to much less.

You can verify that the...

How do you know it is being truncated?