Viewing 15 posts - 2,566 through 2,580 (of 2,756 total)
Is this what you are trying to accomplish? (Please note I commented out the...
March 15, 2017 at 9:26 am
It would probably be handy if we had:
1 - the code being run that is failing
2 - the linked server connection information
I was re-reading the original...
March 15, 2017 at 9:14 am
Is this some sort of homework assignment? I am confused what "Answer 10" is supposed to be.
but there are a few odd things in your code. Like why...
March 14, 2017 at 3:37 pm
March 14, 2017 at 3:12 pm
"While I agree it should be a single update statement, lets say you have...
March 14, 2017 at 2:13 pm
That is good to know. I knew they both did different things, but I was under the impression that if your parameter was going to be unique for each query,...
March 14, 2017 at 1:56 pm
That to me sounds like you are running a on the per core license model, although I am confused about the "2 CALS" part. That to me sounds like the...
March 14, 2017 at 1:41 pm
It depends on what type of license you bought.
I'd personally be looking at:
SQL Server 2016 Enterprise Edition with SP1
but it depends on what license you...
March 14, 2017 at 11:35 am
As a thought, did you backup and restore the encryption keys when moving the SSRS database?
And if this is SQL Standard, did you remove the entries to the...
March 14, 2017 at 11:30 am
Sounds to me like the plan cache got cleared out and things improved.
Might want to check on the age of your statistics and possibly schedule an update on...
March 14, 2017 at 11:22 am
People keep talking about using a Calendar table to solve the "correct age...
March 14, 2017 at 11:13 am
March 14, 2017 at 10:59 am
In our production server, we are using one query to fetch the result...
March 14, 2017 at 10:45 am
Viewing 15 posts - 2,566 through 2,580 (of 2,756 total)