sql-lover (8/8/2014)

---

We're about to try trace flag T272 as a startup parameter on one of our SQL servers. This trace flag brings the Identity key generator to its previous SQL2008...

GPO (8/7/2014)

---

Every column nullable. No constraints. Not even a primary key. No indexes. I think someone is pulling your leg. What possible reliable use could it be? I'm tempted to...

Gary Varga (8/7/2014)

---

Eric M Russell (8/7/2014)

---

Miles Neale (8/7/2014)

---

Eric M Russell (8/7/2014)

---

The Fault (8/7/2014)

---

Eric M Russell (8/7/2014)

---

Even if the QA environment only has 10% the data volume as production; so long...

Miles Neale (8/7/2014)

---

Eric M Russell (8/7/2014)

---

The Fault (8/7/2014)

---

Eric M Russell (8/7/2014)

---

Even if the QA environment only has 10% the data volume as production; so long as the object schemas, configuration,...

The Fault (8/7/2014)

---

Eric M Russell (8/7/2014)

---

Even if the QA environment only has 10% the data volume as production; so long as the object schemas, configuration, and data cardinality are equivalent,...

Staging a high transaction volume OLTP environment for QA and performance testing is actually much harder than a data warehouse environment. Data Warehouses tend to be static with fewer users....

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....