Viewing 15 posts - 91 through 105 (of 768 total)
This is strange to know why not.
I am doing my AG setup (adding dBs) via my automated script and hence creating multiple files would add more complexity.
Coming...
July 23, 2017 at 12:05 am
Using a stored procedure will greatly reduce that traffic because the stored procedure call will always be much shorter. Also, stored procedures are easier to trace...
July 21, 2017 at 8:00 am
Instead of dropping the base table, can I do something to the existing table? I kind of find that the table is continuously being inserted with records, now if I...
July 20, 2017 at 2:43 pm
I used the below approach. For testing I created another mimic table and tried. It is working. But for large table it will be a mess , I assume.
July 20, 2017 at 1:47 pm
This is not the question.
Lets say the Id column has 25,000 entries. Say, first 1-10 records of ID values between 1-100. 11-100 is somewhere between 257000- 289000 like this....
July 20, 2017 at 12:10 pm
Can not leave it alone. As the ID numbers are about to cross BigInt limit.
July 20, 2017 at 11:54 am
Awesome. Many Thanks Grant.
One more inputs from you. Even though I have a Non Clustered Index on a table, I still in Execution Plan that it is doing...
July 20, 2017 at 7:30 am
One question -
If there is no index vs an index scan / clustered index scan, will that be the same?
July 20, 2017 at 7:08 am
Nice one. thnx
July 19, 2017 at 8:53 am
I can see that the "Allow Anonymous Subscription" and Allow Immediate Updating Subscriptions are False in the GUI I can.
Is that what you are saying to be disabled,...
July 19, 2017 at 8:37 am
I will use that as an additional measurement as you said will try to check the query hash option.
by the way, are query_hash and query_plan_hash are same?
July 19, 2017 at 8:04 am
Can you suggest how do you use the Extended event to capture the details? I mostly use set IO profile On and get the details. But here in my case...
July 19, 2017 at 7:38 am
what made you decide it needed that index? --In o/p results the columns were missing, so added them.
How often is the query called? ---This is not part of...
July 19, 2017 at 7:17 am
Well, I do not use the missing indexes std script to use the indexes. I check the execution plan and find the bottleneck say (index scans, clustered index scans, book...
July 19, 2017 at 6:37 am
Viewing 15 posts - 91 through 105 (of 768 total)