Viewing 15 posts - 3,406 through 3,420 (of 8,761 total)
Paul Giles-Randall (7/25/2016)
I have a cursor that pulls out a set of ids and amounts. The data is as follows:
ID ...
July 25, 2016 at 10:07 pm
shelleybobelly (7/25/2016)
OK thanks, so far I see 2008>>2012 it works, 2012>>2014 it works. This is very encouraging news, indeed. Anyone done 2008>>2014?
The structure was last changed in SQL Server 2005...
July 25, 2016 at 10:01 pm
sharonsql2013 (7/25/2016)
I am trying to plot map in Reporting tool. I see that we need spatial data in SQL.
All our SQL table has is Country , City and Region....
July 25, 2016 at 9:48 pm
Nothing unusual as such, PLE is only one of the memory related counters and there can be many reasons for it to drop on an sparse memory resource instance like...
July 25, 2016 at 1:38 pm
As I mentioned before, reconstructing the XML with the changed values and do a normal update is one way of doing multiple updates on an XML in a single operation
😎
USE...
July 25, 2016 at 1:22 pm
komal145 (7/25/2016)
I need to pull previous day data from midnight to midnight . Meaning 7/25 12:00 am to 7/25 11:59pm.how to get this?
Quick question, what data type is your date...
July 25, 2016 at 12:38 pm
ChrisM@Work (7/25/2016)
Alan.B (7/25/2016)
Maybe it's Monday a Monday morning thing but even the small things are annoying me today. Just ran accross this:
[Gender] varchar(100) NULL,
It's fine! I've seen NVARCHAR for gender...
July 25, 2016 at 10:20 am
Quick question, is there an Error 18456 entry in the logs and if so, what is the ERROR STATE?
😎
July 25, 2016 at 3:45 am
Further questions to the OP
😎
1) Do you really need the OrderID in the table? If the model has something like [Customer]---<[Order]>---[Produc] construct the OrderID is redundant as the Orders Fact...
July 25, 2016 at 1:11 am
abhishek_300 (7/24/2016)
July 24, 2016 at 11:20 pm
Doctor Who 2 (7/24/2016)
July 24, 2016 at 10:21 pm
Jeff Moden (7/24/2016)
Deg-235673 (7/24/2016)
I nedd code to purge or clear sql server logs (current) not database logs"Current" log? What mistake are you trying to cover up?
He he, was thinking...
July 24, 2016 at 1:09 pm
At the first glance the statistics look way off, have those been updated recently? Further the index seek on [TRAFFILOG_GEO].[sys].[extended_index_2066106401_384000].[TBL_STREET_ROAD_NEW#ISRAEL_geom].(Spatial) is quite hefty, are you using FORCESEEK? A range scan...
July 24, 2016 at 1:02 pm
Will have a look at this when I can, cannot see the any DDL for any indices though.
😎
Still puzzled why on earth (pun intended) you would use two dimensional geometry...
July 24, 2016 at 12:36 pm
cboneill181 (7/23/2016)
July 24, 2016 at 11:08 am
Viewing 15 posts - 3,406 through 3,420 (of 8,761 total)