Viewing 15 posts - 1,216 through 1,230 (of 1,464 total)
SQLRNNR - Wednesday, March 29, 2017 9:23 PMlonely
lovely
March 29, 2017 at 11:35 pm
March 29, 2017 at 11:35 pm
With some more digging, on my system, this error is caused by a partition scheme
SELECT
Indexname = i.name
, IndexType = i.type_desc
March 29, 2017 at 1:50 pm
March 29, 2017 at 1:36 pm
I've just tested the logic below for @Begin_Period = 201701 and got "201700" for @Last_Period....
March 29, 2017 at 12:52 pm
March 29, 2017 at 11:44 am
How to join Employee and Student tables with HR table, - using ID and date...
March 29, 2017 at 12:35 am
There is no one-size-fits-all for indexing.
You need to analyse the various queries that run against each table. That will shape the indexes that you add.
March 28, 2017 at 2:20 pm
March 27, 2017 at 11:50 pm
March 27, 2017 at 10:18 pm
March 27, 2017 at 3:07 pm
March 27, 2017 at 2:50 pm
--00000000
--02005523
So with the patindex is there a way...
March 27, 2017 at 7:55 am
Viewing 15 posts - 1,216 through 1,230 (of 1,464 total)