Viewing 15 posts - 751 through 765 (of 22,219 total)
You sure it's a table and not a function or a view? A simple select on one table shouldn't place locks on a second table, even if there are foreign...
"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, 2022 at 3:20 pm
Whoever did the install needs to add your login to the admin role on the instance. And yeah, you need to be admin on the SQL Server instance to actually...
"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 19, 2022 at 1:53 pm
Like anything else, practice, practice, practice. Create a database in Azure SQL, then figure out how to access it, how it gets backed up, how to restore it, build tables,...
"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 19, 2022 at 1:51 pm
Spammed 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
October 14, 2022 at 3:05 pm
To only do a subset of the data, you're very limited. Transactional replication is probably your best bet, but you will need to deal with the separation of the domains,...
"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 14, 2022 at 1:21 pm
There are probably an infinite number of ways to schedule a backup. However, most people will use SQL Agent, which is built right into SQL Server instances (assuming you're...
"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 14, 2022 at 1:18 pm
Dataminds Belgium 10/11 oktober was great
100% agreement
"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, 2022 at 3:27 pm
Extended Events are your bestest friend. Specifically, in addition to the normal query captures of rpc_completed and sql_batch_completed, you can look at ole_db_data_reader to see remote queries specifically.
"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, 2022 at 2:34 pm
My answer to this is always the same. What are the Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) of the organization? With those defined, can you prove that...
"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, 2022 at 2:30 pm
No arguments here.
"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 10, 2022 at 4:13 am
I've seen the SQL Edge in action. It's just SQL Server under the covers. That's your single best bet. Just backing up @Ant-Green.
"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 7, 2022 at 2:09 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
October 6, 2022 at 1:01 pm
Have you looked for disc corruption? It honestly looks like things are messed up at a low level.
"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 6, 2022 at 12:58 pm
Microsoft's recommendations are pretty good, and, I think, based on Jonathan Kehayias' guidance.
"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 5, 2022 at 2:27 pm
I also suggest you start using <> rather than != for 'not equal to'. <> is a more widely accepted SQL standard than !=, as far as I know.
Optimizer...
"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 5, 2022 at 12:56 pm
Viewing 15 posts - 751 through 765 (of 22,219 total)