sounds like a data problem: either the data being passed in doesn't find anything, causing a failure of some sort, or you're not passing in what you expect (perhaps 'a...

Jeff's "fastest way to clear a table" springs to...

Just wanted to confirm so it took me a little longer to get free. That said - it's actually straightforward: in a data flow task in the SSIS...

The event status means the same in both cases. It's just that one of the nodes isn't geared to pulling up the right message description for you. The...

do it in CLR, or SSIS. Using T-SQL is going ot be a crude, dangerous way to do it. You can always trigger these things from within T-SQL.

You're...

The Dixie Flatline (3/28/2010)

---

Once again, it depends! 😛

From BOL on Nonclustered Index Structures:

If the table has a clustered index, or the index is on an indexed view, the row locator...

Try this:

http://blogs.msdn.com/sqlserverfaq/archive/2009/08/27/sometimes-you-do-not-see-the-proper-event-description-of-sql-server-events-in-the-application-log.aspx

Do yuo get the same info if you use the event viewer from the actual server itself? You usually get the "missing description" message if your local machine is...

Two things to be wary of:

- ORDER BY doesn't guarantee the order of inserting into a table. At best - you can count on it to guarantee the...

HIPAA actually has very little to do with encryption on the DB side. It's more with tracking who is accessing what, and whether they have permissions. It's more...

CirquedeSQLeil (3/22/2010)

---

Lynn Pettis (3/22/2010)

---

CirquedeSQLeil (3/22/2010)

---

Going on 15 for me. Feels like about 5 - until I try to remember details of those early years. It's hard to remember...

Have you excluded the data directories from virus scanning? How about rebuilding all indexes on the instance which is installed?

That said - unless it's really large - I'd agree...

You can also do it this way:

AND (P.PAprojmngrid =

CASE

WHEN @Discipline = 'Surveying' THEN '07'

WHEN @Discipline = 'Civil Engineering' THEN '04'

WHEN @Discipline = 'Geotechnical' THEN '03'

WHEN @Discipline = 'Materials...

mister.magoo (3/26/2010)

---

I have also come across this peculiarity, it is easier to see in this example

declare @a table(object_id int)

declare @b-2 table(object_id int)

Select a.object_id ,c.object_id

from @a as a

...

Phillip - Texas (3/26/2010)

---

What did people do back in the day? (how ever long ago that is for you.) Where did you get your information from, technical manuals and trial...