Grant Fritchey

Forum Replies Created

Viewing 15 posts - 7,696 through 7,710 (of 22,224 total)

RE: MS Access .mdb & .ldb database corrupted

J Livingston SQL (7/19/2014)
...and here is a link that defines your problem exactly...including poor grammar and spelling errors....hmmmmm:-)
http://p2p.wrox.com/access/28374-ms-access-mdb-ldb-database-corrupted.html
OK, that's officially weird on several levels. What the heck is it hoping...
"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 22, 2014 at 5:51 am

#1731385
RE: Shirnk Tlog(LDF) size?

The only way to shrink the size of the file is to shrink the size of the file.
If your file is growing too large, you have a couple of choices....
"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 22, 2014 at 5:48 am

#1731383
RE: 1 Quick question for all the DBA's

Learn PowerShell.
Automate all the things.
"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 22, 2014 at 5:46 am

#1731382
RE: Suggest me the best choice regarding Importing Data & Indexing

Yeah, I agree with John, test it.
It's a pretty standard approach when you're doing large scale inserts to drop the indexes. This is because maintaining indexes across all the inserts...
"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 22, 2014 at 5:44 am

#1731381
RE: Accessing tables across databases?

If you need to access data on more than one database within Microsoft Azure SQL Database, you must do that at that application level. The databases are absolutely isolated from...
"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 22, 2014 at 5:40 am

#1731379
RE: What would your answer be for this question?

The one thing I would start with is gathering performance metrics. Know what is happening on the system. What do the wait stats look like. Do we have queuing somewhere....
"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 21, 2014 at 3:45 pm

#1731241
RE: How to run query execution plan for parameterized queries?

You can pull the plan generated out of cache using dynamic management views such as sys.dm_exec_query_stats combined with sys.dm_exec_query_plan. You can also use extended events to capture either estimated or...
"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 21, 2014 at 3:41 pm

#1731238
RE: DR Approach

The best piece of advice, go and get someone who knows what they're doing. You go past about 2-3tb and the rules change pretty radically. It's not something you can...
"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 21, 2014 at 4:06 am

#1730946
RE: Anyone going to SQL Bits 17-19 June Telford ICC, UK

Great seeing you guys. SQLBits has some kind of magic perpetual engine, it keeps getting better.
"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 20, 2014 at 6:35 am

#1730861
RE: Are the posted questions getting worse?

SQLRNNR (7/17/2014)
Eirikur Eiriksson (7/17/2014)
Grant Fritchey (7/17/2014)
Threadizens!
Make sure we talk if you're Telford this week. The Red Gat Army is travelling up there this afternoon.
Would that be this bunch?
😎
That looks eerily...
"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 20, 2014 at 6:20 am

#1730860
RE: Suggestions on how to improve this View that is using correlated subqueries

T-SQL beginnger (7/17/2014)
Grant, can you please give me the link of that article that you've written ?
It's right there in the post.
"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 20, 2014 at 6:18 am

#1730859
RE: Moving a database from sql server 2005 to a new VM

Basically, run through the Object Explorer in SSMS. You have the database backup, so that's done. So, Security, logins & roles next. Then Server Objects, usually just linked servers, but...
"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 17, 2014 at 5:35 am

#1730203
RE: Deadlock

You don't have to turn on a traceflag any more with SQL Server for deadlocks. The full deadlock graph is available in the system_health extended event session.
Posting the deadlock...
"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 17, 2014 at 4:57 am

#1730189
RE: notify when a particular field changes

Then you need a way to mark the IP as changed (UpdateDate or something similar) or you have to capture the full data set and then compare it to spot...
"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 17, 2014 at 1:33 am

#1730140
RE: Suggestions on how to improve this View that is using correlated subqueries

Double post. Not sure why. Apologies.
"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 17, 2014 at 1:30 am

#1730138

Viewing 15 posts - 7,696 through 7,710 (of 22,224 total)