Viewing 15 posts - 6,931 through 6,945 (of 39,776 total)
April 3, 2017 at 9:43 am
Not to start any debate or controversy on the topic, but I thought this was a fun April Fools joke I caught Saturday: https://www.youtube.com/watch?v=hoGRlS53U_k
April 3, 2017 at 7:17 am
If I get the timing, then yes. I don't believe a batch insert "reserves" any numbers, so it's possible.
If you are concerned, I'd do this
- dbcc reseed...
April 3, 2017 at 7:16 am
April 3, 2017 at 7:14 am
April 3, 2017 at 7:13 am
April 3, 2017 at 7:12 am
prvmine - Sunday, April 2, 2017 2:10 PMquestion should have stated select more than one
Apologies. I try to remember to always do...
April 3, 2017 at 7:05 am
From a quick test, it seems as though each step logs into SQL Server separately. This means the session is different. That makes sense, as each step is independent, can...
April 2, 2017 at 3:33 am
I am converting records from various sytems/databases into a mssql database. I...
April 2, 2017 at 3:21 am
I'd follow Jeff's solution overall, but a few things I've done when working with a table as a queue. Note, these may or may not apply for your situation. Hard...
April 2, 2017 at 3:10 am
Another vote for disable and use something else, excluding SQL data/log/backup folders.
April 2, 2017 at 3:02 am
SQLRNNR - Saturday, April 1, 2017 9:52 PMThat's the real key there.
+1
April 2, 2017 at 3:01 am
I have typically tried to keep 3 backups where possible. One on the local machine, one remote, one archived offsite. These days the local one probably isn't a big deal...
April 1, 2017 at 6:50 am
April 1, 2017 at 6:48 am
SQLRNNR - Thursday, March 30, 2017 3:10 PMI liked this question about Azure SQL DW. Bring on more please.
Feel free to write...
March 31, 2017 at 1:59 am
Viewing 15 posts - 6,931 through 6,945 (of 39,776 total)