Viewing 15 posts - 5,836 through 5,850 (of 22,226 total)
I really don't sweat what happens after I spit the data out. That's the work of developers, UI experts and report writers. But yeah, those people need presentations too. Go...
"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
July 28, 2015 at 4:27 am
I'd say yes, but test it to be sure.
If you really want to improve performance though, you probably need to get rid of the WHILE loop. That's just a cursor...
"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
July 28, 2015 at 4:25 am
It's only more time consuming when you're writing it. I'm with Gail though, be sure you're using table variables for the right reasons.
"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
July 28, 2015 at 4:23 am
Eric M Russell (7/27/2015)
Based on what you've described above, I see no reason not to simply create a SubItem table.
Absolutely agreed. Based on what we're seeing, maintaining this in anything...
"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
July 28, 2015 at 3:57 am
Eric M Russell (7/27/2015)
"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
July 28, 2015 at 3:52 am
We're talking pretty hypothetical here, but sure, there are situations where normalized storage isn't the most efficient way to manage information. That's actually part of why all the NoSQL and...
"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
July 27, 2015 at 12:22 pm
SQL Server resolves your query into an execution plan. That shows how it chooses to retrieve the information. It tries to filter the information as it retrieves it, rather than...
"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
July 27, 2015 at 11:19 am
Wait types tell you what's causing things to run slow on the system, what it's waiting on. That doesn't tell you what query to look at or what to do...
"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
July 27, 2015 at 11:16 am
chandan_jha18 (7/27/2015)
The code that I executed kept on running for more than 26 hours and appeared to be doing nothing. After putting in a lot of research and reading...
"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
July 27, 2015 at 7:46 am
You can issue powershell commands to copy the files down provided you set up a VPN so that your Azure servers are operating within your network. I've done the opposite,...
"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
July 27, 2015 at 4:43 am
Yeah, compressing a compressed file, I've found, results in a bigger file. So watch commvault.
Nothing special needed with native backup compression other than telling it to do 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
July 27, 2015 at 4:38 am
There's nothing special about how Powershell would issue the command, so I'd have to assume you have blocking or something going on. Look to sys.dm_exec_requests to see what's happening with...
"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
July 27, 2015 at 4:37 am
If the file transfer speed is slow, that could explain the entire issue. You might want to keep a local copy of the backup for DR situations. Otherwise, figure out...
"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
July 27, 2015 at 4:30 am
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
Don't get caught at that one 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
July 27, 2015 at 3:17 am
Hey guys!
What'd I miss? I've been busy.
Achievements Unlocked:
Charlemagne's bones (they wouldn't let me sit in the throne)
Flanders Fields (way too many little white crosses)
Ypres (inside a WWI dugout)
Somme (idiot boy-child...
"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
July 26, 2015 at 4:15 am
Viewing 15 posts - 5,836 through 5,850 (of 22,226 total)