Viewing 15 posts - 9,436 through 9,450 (of 22,224 total)
TWH (10/16/2013)
How do you keep current with SQL Server?
Lots and lots and lots of experimentation, reading and listening. I experiment with technologies I don't understand or need to learn more...
"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
October 21, 2013 at 4:55 pm
One thing you can do is to use Red Gate SQL Prompt to format the query, whether it gets saved correctly or 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
October 21, 2013 at 4:48 pm
There are a number of things that could cause differences. I'd focus first on the execution plans for each query. Are they the same? If not, your issues are narrowed...
"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
October 21, 2013 at 4:47 pm
It sounds like a permissions issue. Do you connect to the SQL Server instance with a different login than the one that is running Visual Studio?
You may need to create...
"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
October 21, 2013 at 4:44 pm
I'm pretty sure you can use one of the file splitting utilities to break them apart and put them back together even though they're encrypted. Other than that, you could...
"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
October 21, 2013 at 4:34 pm
Set up a powershell command to connect to each of the servers and run a query. You can even use threading and remoting within powershell to have the queries run...
"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
October 21, 2013 at 4:29 pm
Sorry to say, I don't know anyone working for any of those three. My experiences with all outsourcing agencies is that the responses you get can be very uneven. I'd...
"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
October 21, 2013 at 4:28 pm
In short, you're in a great situation. Leave it alone.
"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
October 21, 2013 at 4:27 pm
You can also use Policy Based Management to look at how many days it has been since a backup was run on a database. That's a great way to double...
"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
October 21, 2013 at 11:13 am
If you hit the issue again, I'd look for blocked processes. It's likely that you had one that was preventing your from completing what you were doing. You could have...
"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
October 13, 2013 at 7:22 am
Another vote for Embarcadero ER Studio. It's a very solid tool.
You might also want to look at SQL Dependency Tracker from Red Gate. It's not a modeling tool, but it's...
"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
October 13, 2013 at 7:21 am
And remember, in addition to what everyone else has already correctly said about it, page life expectancy can change due to things that are not issues. It's pretty normal, for...
"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
October 13, 2013 at 6:10 am
JBrosch (10/11/2013)
"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
October 12, 2013 at 7:43 am
A whole bunch of Threadizens here at SQL Saturday Charleston. I'm sitting next to Wayne as I type this.
Every Threadizen who makes it to the Summit must track me down...
"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
October 12, 2013 at 7:40 am
lsager 34516 (10/11/2013)
"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
October 12, 2013 at 7:36 am
Viewing 15 posts - 9,436 through 9,450 (of 22,224 total)