Viewing 15 posts - 6,646 through 6,660 (of 59,070 total)
Yes, the login isn't correct. That's what the error is.
But I didn't change the login parameters. So I don't know why is working the 1st case...
August 1, 2020 at 8:34 pm
sys.dm_db_index_usage_stats already has all the index usage for all databases and all tables inside it..
Careful now. If, for example, any database is totally unused, it my not show up...
August 1, 2020 at 8:16 pm
p.p.s.
If anyone wants to do some testing of the method I posted or some other method, here's a 500,000 row test table like the OP said ("few hundred thousand") they...
August 1, 2020 at 7:04 pm
p.s.
If you have to do such lookups a whole lot, it would help a whole lot if you materialized the NVP as a very narrow unique Clustered Index table and...
August 1, 2020 at 6:26 pm
Ok... making the assumption that ID1 is actually supposed to be unique, here's the creation/population of the test table that I reformatted the way I normally would write such code...
August 1, 2020 at 6:02 pm
Did you mean to have 2 entries in the StrHold table that have a "6" for ID1 or is that a typo???
August 1, 2020 at 5:24 pm
I'm not seeing any code attached to your last post. What code are you talking about being "attached"?
July 31, 2020 at 11:41 pm
Have you actually looked at the code in Ola's script to see what the issue may be? It could be easier to fix your problem in his code than it...
July 31, 2020 at 11:04 pm
I have a data as below.
Why did you fail to post any DDL? But more than that, why do you think that SQL and the relational model use any...
July 31, 2020 at 10:57 pm
Yes, the login isn't correct. That's what the error is.
But I didn't change the login parameters. So I don't know why is working the 1st case and why...
July 31, 2020 at 2:28 pm
reminds me of a story from one of my favorite books, a truly geeky must read in my opinion, "the soul of a new machine" by tracy kidder. they're...
July 31, 2020 at 2:21 pm
Check out the following for what you can do with ALTER SEQUENCE.
Admittedly, their examples on that page suck. What you're looking for is the example that uses the RESTART...
July 31, 2020 at 1:40 pm
Thank you guys....I really appreciate your reply but nothing of you give me a solution. Everyone talking about the weather, the child and how to dry the rocks with...
July 31, 2020 at 1:22 pm
Ok... my apologies for not reading the original post well enough. My only concern was the /100 thing. Now I understand what's being done.
The CROSS APPLY method works just fine...
July 31, 2020 at 2:56 am
My GUESS with this question is Jeff replied and then the OP was changed as the OP already has Jeff's suggestion implemented.
That would be a good guess, Brian.
July 30, 2020 at 10:04 pm
Viewing 15 posts - 6,646 through 6,660 (of 59,070 total)