Viewing 15 posts - 4,366 through 4,380 (of 39,771 total)
I would search for any usage. If there is none, or you see no wait stats from queries, I'd set this offline first. See if you break anything, and I'd...
February 28, 2019 at 3:38 pm
In the import wizard, you cna write a query for the values, and you could probably use a function in there. Structuring this for the Excel can be cumbersome. You...
February 28, 2019 at 3:37 pm
Please don't grant to the user. Use a database role.
| February 28, 2019 at 3:32 pm RE: Find last record in last 12 months of current recordI'm not sure I understand. Are you looking for only 1 or 2 records per customer? Meaning a purchase within the last year (or calendar year) and possibly a purchase... February 28, 2019 at 3:30 pm RE: DBA left and they shut off his AD accountThere can be flaky issues if you lose an account that owns things. It's worth doing some cleanup, and saving these scripts. You'll use them again. I'd change the... February 28, 2019 at 3:19 pm RE: Pulling the PlugEric M Russell - Thursday, February 28, 2019 7:39 AM It's easy for one or two people to pull the plug on... February 28, 2019 at 9:07 am RE: Verify Read Only Routing using ProfilerExcellent. Glad to hear it and hope everything else is working great. February 28, 2019 at 9:05 am RE: Pulling the PlugSean Redmond - Thursday, February 28, 2019 4:40 AM Isn't this the purpose of pre-defined success/failure requirements? This project shall be deemed a... February 28, 2019 at 9:05 am RE: Pulling the PlugDavid.Poole - Thursday, February 28, 2019 1:04 AM But the value of Concorde was far more than can be expressed by the short-arms-long-pockets... February 28, 2019 at 9:02 am RE: Please move the "CLR Integration and Programming" forum to the "Programming" groupNot sure and not debugging. We'll be cutting over to a new site soon, so it doesn't matter for now February 27, 2019 at 1:22 pm RE: Should the Data Lake be Immutable?jj3pa - Tuesday, February 26, 2019 1:19 PM Maybe I'm missing something, but the CS idea of immutable doesn't mean the variable can't... February 27, 2019 at 8:59 am RE: The RDBMS is Often the Right ToolThey do have a SQL interface, and I'm not sure if this is good or bad. It might be that SQL is just a better way of querying, or at... February 27, 2019 at 8:55 am RE: The Employee TargetCompletely agree. This is one area that I think we do poorly as an industry, and really, the controls for doing this better are cumbersome. I'd really like "sa"/sysadmin... February 27, 2019 at 8:49 am RE: Verify Read Only Routing using ProfilerGood luck. I haven't had issues here, but I do see the docs mentioning that setting to read/write should make clients prefer the secondary. February 27, 2019 at 8:48 am RE: MOT identityApologies for this. I misplaced the testing script, but only 1 should be allowed. Not sure what I was thinking. February 26, 2019 at 8:55 pm Viewing 15 posts - 4,366 through 4,380 (of 39,771 total) |