Viewing 15 posts - 571 through 585 (of 49,571 total)
December 20, 2017 at 12:53 am
You're far from the first to have crashed SQL by running Profiler (and running it from a different server to production is actually far worse)
DO NOT use the...
December 20, 2017 at 12:50 am
Simpler than calling SQLCMD and passing it T-SQL? Ok.
December 19, 2017 at 1:19 am
That's T-SQL, so no, it won't run in command line.
You can run it via the util that John mentioned.
December 19, 2017 at 12:27 am
Leading with the clustered index key means that the only advantage it has over the clustered index is that the new index is smaller. It'll give you gains for queries...
December 18, 2017 at 1:48 pm
December 18, 2017 at 1:13 am
Yup, no problem, providing you restore the full backup WITH NORECOVERY, and that there are no full backups taken between Tuesday and Friday evening.
December 18, 2017 at 12:45 am
Equality predicates first (ComponentID, IsActive, SampleStatusID), then inequality predicates.
If ISActive is the same everywhere, better to remove it from the query, or make the index filtered. If you...
December 17, 2017 at 1:37 am
From the blog post:
A seek requires a predicate and that predicate must be of the form that can be used as a search argument (SARGable)
It's a...
December 17, 2017 at 1:31 am
The index you created will do nothing, because the leading column is the clustered index key, and is hence already indexed.
Key lookups are single-row seeks against the clustered...
December 16, 2017 at 5:10 am
What did the two counters Total Server Memory and Target Server Memory look like over that period?
December 15, 2017 at 3:30 am
December 15, 2017 at 12:40 am
December 13, 2017 at 11:36 pm
No.
However the tables should have clustered indexes
December 13, 2017 at 3:16 pm
Viewing 15 posts - 571 through 585 (of 49,571 total)