Viewing 15 posts - 1,636 through 1,650 (of 2,356 total)
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 26, 2017 at 7:30 pm
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.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 8, 2017 at 7:41 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 7, 2017 at 6:31 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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 6, 2017 at 3:25 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 2, 2017 at 7:30 pm
You do not need to re-initialize. Just add the indexes manually, and everything should be fine.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 2, 2017 at 12:50 pm
is this the actual code? If so, it looks like you are missing a "BEGIN". Michael L John
Also, the %SQL % may be returning true for a number of different applications.
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 2, 2017 at 12:19 pm
It's 70 and sunny. In Pittsburgh. In February. That's the reason.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 23, 2017 at 4:10 pm
You need to use single quote twice.
O''Brien
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 13, 2017 at 2:49 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 11, 2017 at 7:14 pm
Viewing 15 posts - 1,636 through 1,650 (of 2,356 total)