Viewing 15 posts - 5,821 through 5,835 (of 22,211 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...
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...
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.
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...
July 28, 2015 at 3:57 am
Eric M Russell (7/27/2015)
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...
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...
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...
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...
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,...
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.
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...
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...
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...
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...
July 26, 2015 at 4:15 am
Viewing 15 posts - 5,821 through 5,835 (of 22,211 total)