Viewing 15 posts - 3,526 through 3,540 (of 22,213 total)
It could be tons of things. Limiting the selection list allows the Optimizer to do simplification, eliminating unneeded tables within the views (you haven't specified if the views are of...
November 12, 2017 at 8:01 am
I might be misunderstanding you, Grant. Inserts don't have anything to do with...
November 11, 2017 at 7:27 am
Heh... I've been through similar... Sr. DBA candidates that complain to their "handlers"...
November 11, 2017 at 7:17 am
When you create a principal, a login, group or role, you also get a schema with that principal. These roles have schemas. That's what's going on. They are roles first,...
November 10, 2017 at 6:20 am
I'd focus on waits. You need to determine if it's something with the queries themselves or something with the database or something with the server. Waits is going to be...
November 10, 2017 at 5:14 am
November 9, 2017 at 1:24 pm
It can be done, but I haven't done it. You have to set up Service Broker. Then you can have the event target be the Broker service and use that...
November 9, 2017 at 12:39 pm
Key order is important as its...
November 9, 2017 at 6:43 am
Those are first fixed database roles for security. It just happens that roles are also exposed as schemas. Don't think of them as that. Instead, these are security levels that...
November 9, 2017 at 6:22 am
November 9, 2017 at 6:16 am
\\Servername\Backups\dwhCore\dwhCore_FULL_201711050200.bak
Now, question...
November 9, 2017 at 5:57 am
Short answer, it should just work, but test it.
While a bunch of stuff is deprecated, there's very little that is outright gone. While you absolutely should move off...
November 8, 2017 at 4:10 pm
November 8, 2017 at 3:29 pm
Viewing 15 posts - 3,526 through 3,540 (of 22,213 total)