smtzac (8/7/2014)

---

Sorry guys for late response. Not sure what is this table created for . I have scripted out:

CREATE TABLE [dbo].[ABCD](

[A] [uniqueidentifier] NULL,

[uniqueidentifier] NULL,

[C] [nvarchar](100) NULL,

[D] [nvarchar](max) NULL,

[E] [nvarchar](max)...

Recently I thought of something that had never previously crossed my mind: what about purposely testing against a database with fragmented indexes as may exist in a production database? Is...

Try the following:

RANK() OVER (ORDER BY Col1, Col2, Col3)

Notice it's using rank() instead of row_number() and no partition by.

A long running select query may temporarily block a stored procedure attempting an update, insert, or delete on same table. The opposite can also be true, an update transaction held...

Consult with the team and consider all the potential routes by which records are inserted into this table. For example, is it always inserted via the application, or is there...

One approach is to creating your sorted country list is to query whatever transactional table would contain country code. For performance to be acceptable, it's essential that whatever columns you're...

paul.j.kemna (8/4/2014)

---

I guess i will play it safe and change these to IS Nothing rather than = Nothing, even though it appears to work.

I also occasionally use LEN(Fields!FieldName.Value) > 0)...

paul.j.kemna (8/4/2014)

---

When writing an expression in SSRS 2008 to check for blank values (NULL), is there any difference between Fields!FieldName.Value = Nothing and Fields!FieldName.Value Is Nothing? It seems that...

Creating a non-clustered index containing all columns makes no sense. If you create a clustered index on a table, then technically you already have an index that covers all columns....

In the IT arena, I believe that resume font accounts for less than it would for those seeking a position in something like marketing, public relations, or at the executive...

The first thing to do is compare how the execution plan and number of page read/writes differ between the two databases. You can then focus on why. This can be...

Steve Jones - SSC Editor (7/31/2014)

---

Eric M Russell (7/31/2014)

---

If the windows group like 'MyCorp\ProductionDBA' or 'Builtin\Administrators' are members of SYSADMIN, and user account 'MyCorp\JohnSmith' is added to one of these...

If the windows group like 'MyCorp\ProductionDBA' or 'Builtin\Administrators' are members of SYSADMIN, and user account 'MyCorp\JohnSmith' is added to one of these groups, then he has sysadmin privillage. There is...

Steve Jones - SSC Editor (7/30/2014)

---

Eric M Russell (7/30/2014)

---

SQL Server Audit has an 'Addlogin' event and a 'Add Login to Server Role' event. For example, when a login is created...

SQL Server Audit has an 'Addlogin' event and a 'Add Login to Server Role' event. For example, when a login is created or granted membership in SYSADMIN group.

http://msdn.microsoft.com/en-us/library/ms188646.aspx

But this...