Viewing 15 posts - 1,666 through 1,680 (of 22,227 total)
Not that I'm aware of. There are example queries around here on SSC if you look for them.
"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
August 20, 2020 at 10:03 am
If you do a backup & restore, it's a page-by-page copy. If the restore is successful, there's nothing to check. Everything moved.
However, yes, if you use any of the other...
"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
August 20, 2020 at 9:29 am
Random frozen pork chop?
Do launchers require registration and a permit?
Does Anyone offer a safety class?
It seems injuries are rather rare. Or is this something the news ignores?
Cannon's are legal...
"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
August 19, 2020 at 6:56 pm
The number of tools that will let you move things is huge. SSIS will work. So will using the import/export in SSMS. Can you just start with a backup &...
"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
August 19, 2020 at 12:13 pm
The other key word you need is DENY. In addition to GRANT permissions, you can also DENY permissions.
Sounds like the user might belong to a group that has more access...
"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
August 19, 2020 at 12:10 pm
I'd probably lean heavily towards using tasks defined through whatever tools we're tracking bugs and other work in. Especially since those tools usually can be correlated to source control. Since...
"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
August 19, 2020 at 11:40 am
It's for the Task List. The short cuts act as markers there. Got the answer from Twitter.
"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
August 18, 2020 at 12:14 pm
Great question. Not a clue. I just tried it out. It puts a weird looking arrow in there. Several clicks in and around it yielded nothing. Hmm...
"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
August 18, 2020 at 11:45 am
Happy you found the answer to the issue.
"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
August 13, 2020 at 10:33 am
Well, your network persons assurances aside, that looks like a network error.
However, capture the query metrics and the wait statistics. Don't guess. Don't hover at the edges, looking at system...
"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
August 13, 2020 at 10:12 am
First, set up Extended Events to capture the overall performance of the queries on the system. You can use rpc_completed and sql_batch_completed events to capture that information. Personally, in your...
"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
August 12, 2020 at 12:35 pm
Nope.
System databases and system objects are managed by the system. That's 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
August 12, 2020 at 12:26 pm
I particularily enjoy pasting dates into excel, sort of like a box of chocolates ...
Spring Surprise or Lamb's Bladder Cup?
"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
August 11, 2020 at 9:08 pm
Nothing you do is going to show that. A newly restored database has no performance metrics stored with it of any kind.
In order to diagnose this kind of behavior, 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
August 7, 2020 at 12:49 pm
Have you looked at the execution plan? I'd say it's probably the LIKE statement. However, you need to determine how SQL Server is resolving your query and that answer is...
"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
August 7, 2020 at 12:43 pm
Viewing 15 posts - 1,666 through 1,680 (of 22,227 total)