Viewing 15 posts - 4,636 through 4,650 (of 22,219 total)
Any database created as a SQL Database, is the same. It doesn't matter if you create the database using the portal, powershell or T-SQL. It's a database. Databases live 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 5, 2016 at 6:29 am
ChrisM@Work (7/5/2016)
Grant Fritchey (7/5/2016)
"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 5, 2016 at 6:24 am
If there are differences in structure, are there also differences in the amount of data? Take away different data types and different indexes (which makes comparisons impossible really), just having...
"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 5, 2016 at 6:10 am
Just reinforcing what Jeff said. The single most important thing you can do, after contacting ESRI directly, is to test this process. Do not assume that anything we tell you...
"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 5, 2016 at 6:06 am
I'd want the specifics on the error message.
If it's getting timed out, that means it's firing, so it's not an issue that it's an Agent job, or that 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
July 5, 2016 at 6:00 am
The best bet to do this would be to use one of the many mechanisms for getting the Azure SQL Database to a local server and creating a diagram there....
"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 1, 2016 at 4:48 am
You basically have to pick a representative time from before and a representative time from after. Could there be outliers? Sure. But presumably, unless you've done lots of other changes...
"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 1, 2016 at 2:10 am
jasona.work (6/30/2016)
My servers, both QA and production, are locked down to where I've not yet seen a "surprise" database....
"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
June 30, 2016 at 8:24 am
Everyone,
Thanks for the feedback so far. Keep it coming. Any details on any of the horror stories would be very welcome.
"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
June 30, 2016 at 6:04 am
Hello to the water cooler and all the ships at sea.
I could use a little help on some research. Swing by here and contribute. Also, please share it with others...
"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
June 30, 2016 at 2:04 am
When SQL Server 2005 was released, there was an upgrade to ADO. The previous version of ADO had a particular call structure (I forget the precise details, it has been...
"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
June 30, 2016 at 1:37 am
I'd say the same thing. Knowing what the wait statistics were before you moved the SAN and after will tell you a lot. Same thing with query metrics. If you...
"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
June 29, 2016 at 10:46 pm
tindog (6/29/2016)
ChrisM@Work (6/29/2016)
tindog (6/29/2016)
ChrisM@Work (6/29/2016)
tindog (6/29/2016)
Now Wales are after independence from England to 'safeguard' their future...despite the fact that they also voted in favour of Brexit :w00t:
The Welsh aren't like...
"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
June 29, 2016 at 4:14 am
You have to capture performance metrics from the old system and the new system and compare them. You'd want to look at the wait statistics, percentage of cpu, i/o 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
June 29, 2016 at 2:38 am
What's the goal here? To join everything to everything and bring back all the data? To what purpose?
Also, you say "single row per record". What do you mean by this?
"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
June 29, 2016 at 2:35 am
Viewing 15 posts - 4,636 through 4,650 (of 22,219 total)