First, you have to be careful with terminology in SQL Server -- a login and a user are not the same thing.

The login is at the server level, the user...

Yeah, that's crazy.

Is there any way you can "spoof" the database id so it can be something else in the real server but report back to the software what it...

Luis Cazares (8/1/2013)

---

You could find this article useful

http://www.sqlservercentral.com/articles/T-SQL/88244/

SELECT AttribID

FROM MyTable

WHERE FormatID IN (12,15)

GROUP BY AttribID

HAVING COUNT(DISTINCT FormatID ) = 2

EXCEPT

SELECT...

Technically it should be:

LEFT(myString, CHARINDEX(' ', myString + ' ') - 1)

unless you want a trailing space in the result :-).

Adding the "+ ' '" will cause the code to...

You can use the general calc shown below to get the nearest day of any day:

SELECT

date,

DATEADD(DAY, DATEDIFF(DAY, '19000101', date) / 7 *...

FILLFACTOR can have a major impact on performance, depending on the table and the data usage patterns.

However, a FILLFACTOR of "80" is not necessarily good or bad in and of...

webrunner (7/25/2013)

---

Thanks, Scott,

By "prevents the actual statement from running" do you mean the original DELETE statement? And then any code in the trigger after the ROLLBACK does get run? That...

Eugene Elutin (7/25/2013)

---

webrunner (7/25/2013)

---

Thanks, Eugene, I see. I had commented out the ROLLBACK for my INSTEAD OF trigger so didn't understand the behavior you just posted with the test code....

Easy enough to demonstrate that:

USE tempdb --you can use a "real" db if you prefer

GO

IF EXISTS(SELECT 1 FROM sys.tables WHERE name = 'table1' AND schema_id = 1)

...

Eugene Elutin (7/25/2013)

---

Alexander Suprun (7/24/2013)

---

It's so untrue...

RAISERROR has nothing to do with the transaction.

It's...

webrunner (7/24/2013)

---

Alexander Suprun (7/24/2013)

---

Remove ROLLBACK from the trigger and lower severity of RAISERROR to 10, in this case SSMS won't show any errors, rows will disappear from the UI (but...

You don't need to explicitly cast it in this case, because integer has a higher precedence than varchar, so SQL will implicitly force the varchar to integer.

You should check the...

From a performance standpoint, a single table can work just as well as partitioning in many cases as long as you have the correct clustered index. But if you've...

This is why cursors exist. Just use a cursor, unless you have an extraordinarily high volume of emails to send.

CREATE TABLE [dbo].[TestData](

[text] NULL, --??...

You'll get better performance from clustering on the date -- as the only or first key column -- if date/date range is specified in the queries.

I believe a...