Based on the example in this BOL Article, I'd say varbinary(128).

Do you need to do it at insert or is it an update AFTER the rows are inserted?

It is possible to do it in both cases. Seems like an...

Comparison to NULL always yields UNKNOWN not True or False so you probably do want the OR b.deptid IS NULL logic to make sure your query is correct.

You say that...

I'd like to know why DBCC CLEANTABLE worked and what it actually cleaned up because it seems like there was some metadata kicking around for that table somewhere that caused...

Backing up a SQL Server database is an online operation so you don't have to suspend operations on the database in order to get a backup of a consistent state....

You can start by using some of the metrics built into SQL server using DMV's like sys.dm_exec_query_stats and sys.dm_exec_procedure_stats to look at most executed queries and longest running queries. ...

Congrats.

Brandie Tarvin (7/11/2015)

---

Kind of irked this morning. Found out this morning that the SQL Saturday call for speakers in Orlando closed after only a week.

Usually the call for speakers is...

You need something like the following (this won't work as written, but it should give you an idea):

=(IIF(fields!date1.value>IIF(fields!date2.value = "", Today(), fields!date.value),"late","on time"))

For example, you may need to use the...

Sounds like either "bad" parameter sniffing. You can check the parameter values for the slow runs to normal runs by using ExecutionLog3.Paramters column and see what values are causing...

Here's a quick test I threw together to see what happens:

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

BEGIN;

DROP TABLE dbo.KeyTest;

...

Wish I could be more help, but I don't know anything about Universe DB. I just looked at the documentation, http://www.adbk.se/manuals/uv10/uvdoc/UniVerse/Sqlref.pdf, to try to provide some help. Since...

Lowell (6/29/2015)

---

i have a couple of tables like that in a vendor database; with a single column index on the PK;

the funny thing is, that NC index gets used a...

Congratulations Alan. Nothing like the first child.

My instinct is to change the clustered index to be unique and drop the non-clustered because I can't think of an instance where the optimizer would choose the non-clustered unique...