jasona.work (9/16/2015)

---

Ed Wagner (9/16/2015)

---

jasona.work (9/16/2015)

---

Hmm...

The server is a *little* bit loud...

Like, sitting on the workbench, basement door closed, can still hear the fans roaring on the main floor loud...

This...

Could be...

Utopia

Sean Lange (9/16/2015)

---

I have a very awful table structure that I have to deal with. This is in an ERP and I can't change the tables...yes I know how completely...

tauseef.jan (9/15/2015)

---

hi,

I have a table in PRODUCTION server with more than a billion records. I am running the below query to check the exact number of records in it.

select count...

Minnu (9/16/2015)

---

Hi Team,

I have a database with Name 'Marketing' and i have created another database 'Marketing1' in same instance.

i want to bring the 'Marketing' database offline and alter 'Marketing1' to...

pietlinden (9/15/2015)

---

Anybody using (and like) PowerView? Are there any good resources on it? I kinda like PowerPivot (just having a hard time getting my head around it)... but PowerView...

Rumble

In the case of using the convert function on the column in the where clause, I would only consider it if there are relatively few rows being sought, as those...

Jeff Moden (9/15/2015)

---

Heh... remind me not to even attempt such questions in the future. I mentally added "and do it right" to the question which, of course, would have...

Steve Jones - SSC Editor (9/15/2015)

---

The idea in checksum is to reduce work. ALL hashing algorithms have the possibility of collisions. The faster/shorter/cheaper the algorithm is, the more likely there...

Commute

Trying this out :Whistling:, I'm wondering on what kind of logic Bobby is using.....

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH T(N) AS (SELECT CONVERT(TINYINT,N,0) FROM (VALUES (1),(2),(3),(4),(5))AS X(N))

,BASE_DATA AS

(

SELECT

...

Same column order rule applies there too;-)

😎

robin 66943 (9/15/2015)

---

This makes no sense to me. If the checksum is calculated differently, then when the checksums match that will most likely imply the data is different, not the...

Without any further information on the data, structure or even an execution plan, it obviously is a pure guesswork. Can you supply some more information such as DDL, sample data...