Viewing 15 posts - 1,636 through 1,650 (of 2,356 total)
Tempdb is recreated with each restart.
There is no need to sync between nodes.
I have been doing this same thing with tempdb on my clusters for years.
March 8, 2017 at 7:41 am
If this is the approach you have to use, I think you should capture every login name, and every program name for every login.
Examine the results of that after a...
March 6, 2017 at 3:25 pm
March 6, 2017 at 3:21 pm
Change the size of the batch in the SSIS package to a smaller number.
And, floow Jeff's suggestion to try to re-write thje query
March 2, 2017 at 7:30 pm
You do not need to re-initialize. Just add the indexes manually, and everything should be fine.
March 2, 2017 at 7:28 pm
What RAID controller are you going to buy?
The way in which you are describing things leads me to believe that you are not isolating drives onto different raid...
March 2, 2017 at 3:24 pm
If you change the properties of the article, it is not going to add the indexes. You will need to reinitialize the subscription.
Test it yourself. Create a new...
March 2, 2017 at 12:50 pm
is this the actual code? If so, it looks like you are missing a "BEGIN".
Also, the %SQL % may be returning true for a number of different applications.
March 2, 2017 at 12:27 pm
In the properties of the article, you need to set the properties to include the indexes. It does not do this by default.
You can also create what ever indexes...
March 2, 2017 at 12:19 pm
It's 70 and sunny. In Pittsburgh. In February. That's the reason.
February 23, 2017 at 4:10 pm
You need to use single quote twice.
O''Brien
February 21, 2017 at 1:59 pm
What YOU can do does not matter. What matters are the permissions that the account being used to run SQL Server holds.
If the service account does not have...
February 13, 2017 at 2:49 pm
February 11, 2017 at 7:14 pm
Viewing 15 posts - 1,636 through 1,650 (of 2,356 total)