steve.ledridge (11/14/2013)

---

Anybody have advice on conversions from "Technical Silos" to "Functional Groups". We are going through a re-org and what might make sense for some skill sets, does not seem...

ksatpute123 (11/14/2013)

---

Thank you for the quick reply.

I have already tried using this approach. It is based on the assumption that there will be only one value per column corresponding to...

LutzM (11/14/2013)

---

Did you try to run the excat code on the server in question?

My guess would be the code will also fai if run from the query window connected to...

UNIONing your queries won't quite get you to where you want to go.

What you want is often called a cross-tab, and here's a way to do it in T-SQL, using...

mssqlnoob (11/14/2013)

---

Hi,

with reference to http://technet.microsoft.com/en-us/library/ms174384.aspx

when I execute the following code

USE AdventureWorks2012;

GO

DBCC SHOW_STATISTICS ("Person.Address", AK_Address_rowguid) WITH HISTOGRAM;

GO

RANGE_HI_KEYRANGE_ROWSEQ_ROWSDISTINCT_RANGE_ROWSAVG_RANGE_ROWS

AC3973FF-355C-47B6-BD71-000E1B6F2C020101

9534050D-1451-46AB-8A48-0137E7BD3997941941

7CCBD34E-3BB7-48C5-AB2E-02472716B5E3611611

34E2CD1E-FA81-4BF4-B9EB-02B4AFF6E3D1411411

B0F69A8C-1C4E-4A41-A710-0BB1865D85AA60716071

it informs me that average_range_rows is 1 yet

Solid area left of...

dwain.c (11/13/2013)

---

wolfkillj (11/13/2013)

---

Ed Wagner (11/13/2013)

---

Greg Edwards-268690 (11/13/2013)

---

venoym (11/13/2013)

---

L' Eomot Inversé (11/12/2013)

---

wolfkillj (11/12/2013)

---

My new blog post on appropriate data types for storing latitude and longitude coordinates is up.

Thanks for indulging...

Jeff Moden (11/13/2013)

---

wolfkillj (11/12/2013)

---

Jeff Moden (11/11/2013)

---

Honny (11/11/2013)

---

As you mentioned there is no Foreign Keys so truncate and load is better.

1. If you drop the table again you have to...

Ed Wagner (11/13/2013)

---

Greg Edwards-268690 (11/13/2013)

---

venoym (11/13/2013)

---

L' Eomot Inversé (11/12/2013)

---

wolfkillj (11/12/2013)

---

My new blog post on appropriate data types for storing latitude and longitude coordinates is up.

Thanks for indulging me in...

Jeff Moden (11/11/2013)

---

Honny (11/11/2013)

---

As you mentioned there is no Foreign Keys so truncate and load is better.

1. If you drop the table again you have to create the table...

terinoe (11/11/2013)

---

I am trying to query from a linked server where a fields is in a list of values queried from my local server. I am not sure how...

Jeff Moden (11/11/2013)

---

There's no guarantee but you could create the less-wide indexes, and see which indexes are used the most over time...

My new blog post on appropriate data types for storing latitude and longitude coordinates is up.

Thanks for indulging me in a little bit of self-promotion. I'm finding that it's...

Of course, the entirely foolproof way to deal with this is to set the servers to UTC time, which doesn't change for daylight savings. It's usually trivial to make the...

Fall is not the time of year to worry about this. When we shift the clocks back an hour, 1:59:59 is followed by 1:00:00 instead of 2:00:00, so your 2:00...

sqlblue (10/31/2013)

---

I have a job that call a SSIS package to call a stored procedure that does insertion of records from a table in staging schema (staging.table1) into another table...