PJ_SQL (8/28/2016)

---

Ran the execution plan for the script and it showed 50% cost for Key Lookup(Clustered) and 50 %Index Seek (NonClustered). It didn't show any missing indexes, but DTA recommended...

I assure you, there's information on the isolation levels in the official documentation (Books Online)

The point of interview questions is to see...

coool_sweet (8/28/2016)

---

(1)how to find nolock?

(2) can a table have only non cluster index?

(3) Design a package to transfer 10 files from FTP and store them to hard drive?

(4)What is self...

It's been like this since there was an Analysis Services (SQL...

It depends both on the total size of the table, and on the number of rows needing a lookup.

Depends on the table size and number of rows needing a lookup. Test for your data set and see which works better for you.

Assuming you know there is only one non-zero leading digit, doesn't matter how many zeroes there are

DECLARE @Number BIGINT;

SET @Number = 1000000017777;

SELECT CAST(RIGHT(@Number, LEN(@Number) - 1) AS INT);

erico (8/27/2016)

---

The Detach/Attach operation might be doable going across different versions from operation standpoint, but it is very important to have compatibility modes in sync from the perspective of...

https://msdn.microsoft.com/en-za/library/ms189799.aspx

Permissions

To create a DML trigger requires ALTER permission on the table or view on which the trigger is being created.

To create a DDL trigger with server scope (ON ALL SERVER)...

Ok, so if you're after performance improvements, why are you wasting time looking at partitioning?

Partitioning is for data management, fast loads, archiving, that kind of thing, if if you...

Depends. Why are you partitioning the table?

The purpose behind the partitioning will determine what your partition columns should be.

Mostly because it doesn't leave you an intact copy of the DB on...

erico (8/25/2016)

---

Detach/Attach can only be done with databases in the same SQL Server compatibility mode - meaning you can only for example Detach/Attach a 2016 database in the SQL server...

Yes, because unlike in the US, turning left (would be right for the US) through...

If you're going up to Inverness, take the train from Edinburgh. Goes...