Viewing 15 posts - 751 through 765 (of 22,227 total)
You can't "restore" the mdf file on its own. You can attach it though. Here's an example.
By the way, sounds like the database is in FULL recovery, but 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
November 2, 2022 at 1:52 pm
Nope. Not really. There's no tracking mechanism for table, view or index. Not like what you're asking for.
What you can do is track the queries in the system using "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 1, 2022 at 12:39 pm
No money from it, but I built a database and an application that stored information about the location of veterans grave sites. This was then used by the Veterans of...
"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 31, 2022 at 12:57 pm
Excellent feedback. Thanks Peter. Couldn't agree 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 30, 2022 at 9:36 pm
Jeff's on target from what I can see. I don't see both queries and locks there in a way that you can accurately associate them with one another.
"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 25, 2022 at 12:47 pm
Oh! Missed that. Sorry. Yeah, you're hammering your CPU with that. I'd strongly suggest stopping.
"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 24, 2022 at 3:57 pm
Considering there's something urgent going on, why not tell us exactly what it is that you're trying to do and then we might be able to better help. All these...
"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 24, 2022 at 1:35 pm
Sp_whoisactive is querying the DMVs, and, depending on how you run it, an aggregation of multiple runs. Profiler is capturing through trace events, one execution at a time, providing 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 24, 2022 at 1:28 pm
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
Viewing 15 posts - 751 through 765 (of 22,227 total)