PiMané (1/31/2013)

---

I'm trying to determine the fastest way, and as far as I tested, the sys.partitions is the fastest but just don't know how reliable the info is...

DBCC UPDATEUSAGE is...

It's reliable as an approximate count for an individual table or index. You may be able to...

What country are you doing? I'm going to assume...

It has been awhile since I've done any VB.net, but don't you need a WithEvents variable?

e.g.

Dim WithEvents ev As New EventClass

Sub TestEvents()

ev.RaiseEvents()

End Sub

Sub ev_EventHandler() Handles ev.XEvent,...

Facebook terms of service states: -

Safety

---

We do our best to keep Facebook safe, but we cannot guarantee it. We need your help to keep Facebook safe, which includes the following...

A friend works somewhere with a DA (Data Administrator) in addition to three DBAs (Production, Development & Backup). All four are heads of small teams. Admittedly, I've never worked anywhere...

Jeff Moden (1/9/2013)

---

Careful now. I realize that Lynn has already pointed it out but I want to emphasize it... The example that Lynn gave is the correct...

In your description, you've not described any use for the table "taxes".

This fulfils your description: -

SELECT *

FROM (SELECT co.company, co.location, co.order_no,

CAST(co.order_qty AS INT)...

Did anyone get anywhere with this?

10e5x (1/4/2013)

---

omg i am losing the discussion over here... so the recommended solution to me is which? And is it a typo or? why there are two '??' sry for...

SET NOCOUNT ON;

DECLARE @a DATETIME;

SET @a = GETDATE();

--First

SELECT DATEADD(DAY, 0, DATEDIFF(DAY, 0, @a ));

--Second

SELECT DATEADD(DAY, DATEDIFF(DAY, 0,...

10e5x (1/4/2013)

---

So if i have an sql statement in my execute sql task that looks something like this:

Delete from TABLE where (CREATION_D = ?)

CREATION_D is the column i am discussing...

Grinja (12/21/2012)

---

Try the following:

--Load sample data

CREATE TABLE #Invoice (ID INT, InvoiceNumber INT, Created DATETIME)

INSERT INTO #Invoice

SELECT 6,125870808, '2012-12-18 15:45:30.000'

UNION ALL

SELECT 5,125870808, '2012-12-18 12:23:27.000'

UNION ALL

SELECT 4,125870808, '2012-12-18 06:45:06.000'

UNION ALL

SELECT 3,125870808,...

dwain.c (12/20/2012)

---

Looked like a single quote when...

davidandrews13 (12/21/2012)

---

talking of being SARGable, i was reading this article:

http://en.wikipedia.org/wiki/Sargable

and didn't quite understand this line

The typical thing that will make a sql query non-sargable is to include a function in...