Viewing 15 posts - 286 through 300 (of 1,246 total)
July 9, 2018 at 11:26 am
I got the "correct" wrong answer simply because I made the faulty assumption that SQL Server would simply use the 1st character and "shave off" any subsequent characters... like it...
July 9, 2018 at 9:11 am
I don't know that I'd break things down along those lines per se... If you had vastly different security concerns for each of those areas, then maybe...
Speaking only for...
July 6, 2018 at 1:04 pm
Another fast option is partition switching.
Here's a quick example...USE CodeTest
GO
/* Create a couple of tables to test with. */
CREATE TABLE dbo.TableProd (
SomeID...
June 20, 2018 at 7:48 am
June 7, 2018 at 9:48 am
June 5, 2018 at 2:39 pm
June 5, 2018 at 2:34 pm
June 4, 2018 at 10:38 am
May 31, 2018 at 8:34 am
May 31, 2018 at 8:30 am
Viewing 15 posts - 286 through 300 (of 1,246 total)