Viewing 15 posts - 6,016 through 6,030 (of 8,761 total)
JeeTee (3/17/2015)
I'm writing a package to move the bulk of a table from one server to another, which amounts to about 25m rows. I'm not so worried about how...
March 17, 2015 at 3:53 pm
Denise McMillan (3/17/2015)
March 17, 2015 at 3:48 pm
paulze2000 (3/17/2015)
March 17, 2015 at 3:36 pm
Quick suggestion
😎
CREATE TABLE #Time ([TimeStamp] DATETIME, TimeDiff INT)
INSERT INTO #Time (TimeStamp)
VALUES ('2014-09-02 07:51:02.810'), ('2014-09-02 07:48:09.567'), ('2014-09-02 08:37:09.647')
, ('2014-09-02 16:16:42.593'), ('2014-09-02 08:06:13.387'),('2014-09-02 14:32:00.113')
;WITH...
March 17, 2015 at 3:27 pm
The Redneck DBA (3/17/2015)
Msg 9020, Sev 16, State 2, Line...
March 17, 2015 at 2:56 pm
add2700 (3/17/2015)
This issue has existed for a long time. SQL Server 2005 SP2 on server 2003.
First thought is that fixing the ageing OS/SQL Version should be a higher priority than...
March 17, 2015 at 2:45 pm
SQL_Kills (3/17/2015)
Jeff, The Yesterday_Amount should show the Amount the Amount the ID was for yesterday. Thanks
Could you elaborate on Dwain's questions please?
😎
March 17, 2015 at 2:28 pm
ScottPletcher (3/16/2015)
CELKO (3/12/2015)
Since BIGINT is larger than the number of atoms in the universe, we do not use it very often.
No, not even close. There are at least...
March 17, 2015 at 2:15 pm
CELKO (3/17/2015)
No, not even close. There are at least 10^78 atoms, whereas bigint only covers just under 10^20.
My bad :rolleyes:
A quick Google: it is believed that between 120...
March 17, 2015 at 2:02 pm
The desired results do not match the sample data + the logic, can you elaborate on this?
1) What is the definition of 'O'?
2) Why the difference between the requirements and...
March 17, 2015 at 1:39 pm
Luis Cazares (3/17/2015)
Can someone help with a crystal ball or interrogation system for this thread?http://www.sqlservercentral.com/Forums/Topic1668185-391-1.aspx
You will have to ask Koen, he supposedly took it to the shop for repair and...
March 17, 2015 at 1:32 pm
Quick suggestion, group and aggregate the set separately and then union the two sets
😎
USE tempdb;
GO
SET NOCOUNT ON;
--Existing Data
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#Table1') IS...
March 17, 2015 at 1:24 pm
Ed Wagner (3/17/2015)
djj (3/17/2015)
crookj (3/17/2015)
Ed Wagner (3/17/2015)
SQLRNNR (3/16/2015)
Ed Wagner (3/16/2015)
Jeff Moden (3/14/2015)
eccentricDBA (3/13/2015)
Ed Wagner (3/13/2015)
crookj (3/13/2015)
Revenant (3/13/2015)
Ed Wagner (3/13/2015)
djj (3/13/2015)
crookj (3/13/2015)
Ed Wagner (3/13/2015)
djj (3/13/2015)
Ed Wagner (3/13/2015)
jasona.work (3/13/2015)
Stuart Davies (3/13/2015)
SQLRNNR (3/12/2015)
droneBee
Happy
Peaceful
Flower...
March 17, 2015 at 7:28 am
March 17, 2015 at 5:34 am
Viewing 15 posts - 6,016 through 6,030 (of 8,761 total)