Viewing 15 posts - 151 through 165 (of 7,191 total)
Since SQL_DETAIL and ROWID are defined as nchar and nvarchar, you might try putting an N in front of the strings in your query. I can't see that the absence...
February 20, 2020 at 10:50 am
Have a look at the errorlog of the server that your data collection is failing to connect to. That will give you the precise reason for login failure. That information...
February 19, 2020 at 10:14 am
Your requirement isn't very specific, so here's a very general answer. You have three choices that I can think of:
February 19, 2020 at 10:11 am
No - that's just a sidebar. That's what you would do if you wanted to update statistics only, and not rebuild your indexes. I'm sure Jeff will explain the benefits...
February 18, 2020 at 9:13 am
John
That's not (just) updating statistics - it's index maintenance. When you rebuild an index, you should plan to have at least the same amount of free space in...
February 17, 2020 at 4:40 pm
If that's your largest index then yes, that will probably be enough. Don't forget to allow also for the growth of your data over time.
John
February 17, 2020 at 3:55 pm
Your stored procedure will process indexes one by one, I believe, so you need as much free space as the size of the largest index (or half as much as...
February 17, 2020 at 3:12 pm
That's not (just) updating statistics - it's index maintenance. When you rebuild an index, you should plan to have at least the same amount of free space in your database...
February 17, 2020 at 2:39 pm
Why are you looking for an alternative approach - does yours not work? What processing do you do on each row once you've selected it?
John
February 17, 2020 at 12:00 pm
OK, good. Please will you share the relevant snippet from the Extended Events file, and the script you're using and the results it returns?
John
February 17, 2020 at 11:57 am
Probably permissions. When you run it from the command line, it runs in the context of the account you are logged in as. When you run it from a job,...
February 17, 2020 at 11:55 am
It's not clear - what is showing as Update Statistics? Where did you find that information - in a log file, an audit, or somewhere else?
John
February 17, 2020 at 11:51 am
Best to test your code before you post it, just to check that it works! Did you try DATEPART as suggested?
John
February 17, 2020 at 11:44 am
So you are truncating a large table and then inserting a large amount of data into it, and all the time other users are trying to use the table? Do...
February 13, 2020 at 4:26 pm
Sounds like you have databases that have different collations from each other or from the server collations. You'll need to put a COLLATE clause in that script wherever you have...
February 13, 2020 at 12:03 pm
Viewing 15 posts - 151 through 165 (of 7,191 total)