Viewing 15 posts - 6,451 through 6,465 (of 59,070 total)
So if I were going to change the table's fields from Nvarchar to varchar as long as they are not executing
example: SELECT ... FROM ... WHERE...
September 4, 2020 at 2:44 pm
Before you publish your project to Azure App Service, you must first upload your project's database to Azure SQL Database.
Heh... do tell... Just how would you accomplish such a...
September 4, 2020 at 2:31 pm
I want to read some competent answer too, just will wait here
Then go to the other post people have cited. 😉
Since your nondescript post strongly resembles a "test prelude"...
September 4, 2020 at 2:24 pm
Just to add some clarification to this problem and "bump" it because it is an interesting issue...
Where are you copying the backups FROM? For example, are you copying from on-prem...
September 4, 2020 at 2:14 pm
Jo
A query (or certainly one that doesn't involve a remote server) will never time out - it will be the application that kills it, not SQL Server.
John
I'm not sure...
September 4, 2020 at 2:04 pm
Autoincremental bigint ID is never a good candidate for a clustered index.
"Never" is a pretty big word here. There are some exceptions. For example, you're using the Autoincremental ID...
September 4, 2020 at 1:43 pm
You bet. Thank you for the feedback.
I use the code to find the worst performing queries even each execution is measured in milliseconds. Repetition means a lot. In other words,...
September 3, 2020 at 9:06 pm
In contract to @JeffModen's response - it is also possible that the client(s) are sending varchar parameters and all of those queries are using implicit conversions and full...
September 3, 2020 at 8:56 pm
In contract to @JeffModen's response - it is also possible that the client(s) are sending varchar parameters and all of those queries are using implicit conversions and full index...
September 3, 2020 at 8:55 pm
Steve Jones - SSC Editor wrote:As Jeff noted, include TRUNCATE in here.
I did include TRUNCATE in the trans, from the start. Not exactly sure how else you want the transaction structured.
Agreed... didn't see...
September 3, 2020 at 8:51 pm
As you're finding out, Partitioned Tables don't make such changes easy. I drank the MS "Kool-aid" a couple of years back (only 1.2 TB total, though) and I'm in the...
September 3, 2020 at 3:56 pm
I posted a reply and it was removed as spam. Please explain how my opinion was spam.
Marcus
Artificial "Intelligence" of the automatic SPAM removal code for this forum is the...
September 3, 2020 at 3:05 pm
You have to consider something else that most people don't and that is "Implicit Conversions". You have to know how external code is referencing the table. If it's passing string...
September 3, 2020 at 3:01 pm
Did you ping the IP address to see if the address is still online?
September 3, 2020 at 2:53 pm
Include the TRUNCATE in the transaction. That'll lock the table until a COMMIT is done.
September 2, 2020 at 7:16 pm
Viewing 15 posts - 6,451 through 6,465 (of 59,070 total)