Viewing 15 posts - 4,651 through 4,665 (of 39,740 total)
I wonder if you could put in the virtual server.db.schema.object and this return different values in an AG. Haven't tested, but that was all I could think of for the...
November 19, 2018 at 4:24 pm
Yep, fingers crossed he stumbles but throws a lot to Hill 😉
November 19, 2018 at 9:46 am
You don't have an alias for the second or third tables.
SELECT
t1.WEA
, t2.Date_Time
, t1.Base1
, t1.SSI1
, t2.Base1
,...
November 19, 2018 at 9:46 am
Correct, no. Any use of a system for insights, queries, backup, etc. is considered active use and production.
November 19, 2018 at 9:42 am
Yes, there are free versions of Visual Studio and the BI development workload is free.
You can also use developer of SQL Server for free, or Express.
November 19, 2018 at 9:41 am
What's the code you tried to do these?
November 19, 2018 at 9:40 am
It's not listed in BOL. Perhaps because there could be some issues with AGs/clustering and having the database move between nodes. In that case, the same database you connected to...
November 19, 2018 at 9:38 am
What's the error you get? Also, remove the insert and write the select. What happens here?
November 19, 2018 at 9:35 am
Closing this thread as it has gotten off topic and a little out of hand. My apologies for not doing this sooner.
If you wish to discuss politics or...
November 16, 2018 at 12:52 pm
The more data you delete in one batch, the larger the log records and and the more locks taken. Often easier and faster to delete in batches rather than one...
November 14, 2018 at 11:19 am
That's only a part of what auditing is. Auditing is deciding what information to capture, when, and for this objects. You have the last one, but what information needs to...
November 14, 2018 at 11:07 am
What do you need to audit? You still haven't defined this.
November 14, 2018 at 10:44 am
Viewing 15 posts - 4,651 through 4,665 (of 39,740 total)