Viewing 15 posts - 2,146 through 2,160 (of 22,219 total)
Memory use within Azure is pretty much the same as within SQL Server. Over time, it's going to go to near 100% allocation, always. It includes the cache, so your...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2020 at 2:28 pm
Ah, the joys of old knowledge repeated forever, despite things changing.
Read the docs. System functions can start with @@ and they used to be called global variables. They're not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2020 at 2:24 pm
Would you believe... both.
If you look at an execution plan that is in row mode, not batch mode, it's actually doing all the commands it does, one row at a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2020 at 2:09 pm
Try it with quotes around the table name.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2020 at 2:07 pm
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2020 at 2:05 pm
The host name is dependent on the connection string. If people leave this off, it's why you can't audit for it. You can use HOST_NAME to get this information...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2020 at 1:45 pm
Most people read more than one of the topics (or, like I do, look at which topics are new), so posting a question multiple times just leads to different answers...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2020 at 1:39 pm
Honestly, this is work I would put on to the front-end. There are ways to do translations. Otherwise, you're going to have to do pretty horrible stuff to your T-SQL...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2020 at 1:37 pm
Sounds great. Let me know when that gets implemented. I'm in.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 15, 2020 at 6:47 pm
If you are only storing the XML and not querying it or manipulating it in SQL Server, then I suggest you should use VARBINARY(MAX) rather than the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 15, 2020 at 4:06 pm
(heh... no one uses column store, right? :D) but didn't say so. My bad.
BWA-HA-HA!!!
Exactly.
I sure wasn't trying to correct your answer, just add to it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 15, 2020 at 2:54 pm
It's the choice of a compromise.
Most people are suffering from what they're currently doing. Further, even completely independent sources like the ISE recommend using a password manager. Everything online...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 15, 2020 at 2:53 pm
Yes. That's the one. You're mixing data types such that you have to do CONVERT in some cases and SQL Server is covering for you in others using CONVERT_IMPLICIT. These...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 15, 2020 at 1:26 pm
Query hints should absolutely be the exception, not the rule. So, I'm always inclined to remove them. However, using Chesterton's Fence as a model, we need to ask, why is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 15, 2020 at 12:58 pm
Yeah, I see where the paranoia comes from. However, I can also see how the NSA would prefer a more secure Windows OS.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 15, 2020 at 12:49 pm
Viewing 15 posts - 2,146 through 2,160 (of 22,219 total)