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

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