Nope. 🙁

Thanks

John.

The configuration of the SQL Server is likely not set to accept TCP connections.

Thanks

John.

Hi.

I've seen this before, and it usually means that the distribution stored procedures are fouled up. Assuming that this is transactional replication with continuous updates after a snapshot. ...

The speed of the create depends on the speed of the disk files plus the fragmentation of the underlying disks. Creating a DB on a SAN-based SSD will be...

Roust_m (2/2/2014)

---

Hi,

I need to be able to restore some native compressed backups with litespeed. The reason being, we have very complex test environment build process and want to add...

Jeff Moden (1/31/2014)

---

About the only way that I can think of to increase the performance of inserts when an IDENTITY column is the clustered index (and with the understanding that...

Jeff Moden (2014-01-31):

If by "identity", you mean a column that has the IDENTITY property, there wouldn't be any performance increase for such partitioning if you partition based on IDENTITY column...

Hi. A few more details...

1. Both tables are clustered on a BIGINT identity. This identity would be the value upon which I would partition. Each node in the...

Bruce W Cassidy (1/29/2014)

---

Most date and time dimensions include "banding" or ranges -- year and month, quarters, financial versus calendar, etc. With some nice indexing over the ranges and...

PHYData DBA (1/27/2014)

---

So.... How does this work with selecting values from columns in a table? Using this would take at least two or more conversions per row on the...

PHYData DBA (1/27/2014)

---

John your example has not a single Date or Time data type in it. The question was about Date and Time Values.Did you mean to post some...

PHYData DBA (1/27/2014)

---

Could you give me an example of how this should be done? Maybe you did not understand the questions...

How would YOU take the two different data type...

PHYData DBA (1/22/2014)

---

Jeff,

In reference to your comments about using date and time data types.

How would you recommend we take a date value and a time value and convert them to...

Jeff Moden (1/21/2014)

---

I know it's a personal preference but I've worked with "DateDIM" tables that use date and time serial numbers and I've never understood why people would bother. ...

Kenneth.Fisher (9/10/2012)

---

(snip)

My design is correct for the purpose. It's simple. I didn't need or want a complicated design to demonstrate a subject that can be complicated enough for...