Viewing 15 posts - 10,441 through 10,455 (of 22,224 total)
sqlguy-736318 (9/19/2012)
Does Microsoft provide a standards document for SS design standards?For example: "Column names should be Pascal-cased - ex - FirstName"
Have you ever looked at the databases created by Microsoft?...
"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
September 20, 2012 at 4:17 am
I'm not sure how SQL Server is going to deal with all those correlated queries. I'd love to see the execution plan for this. Can you get the actual execution...
"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
September 20, 2012 at 4:15 am
It's not a problem that I've run into or heard about. Are the connections being made from up to date libraries? The appropriate version of ADO or whatever? That might...
"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
September 20, 2012 at 4:11 am
19000 out of how many plans total? What kind of queries are being run against the system? I'm assuming these are not parameterized queries or stored procedures? If so, 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
September 20, 2012 at 3:54 am
Joy Smith San (9/19/2012)
Suppose a transaction was started before the backup process starts, only one transaction for example.
Backup process back up the pages.. transaction...
"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
September 20, 2012 at 3:51 am
Brandie Tarvin (9/19/2012)
Lynn Pettis (9/19/2012)
Brandie Tarvin (9/19/2012)
Lynn Pettis (9/19/2012)
"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
September 19, 2012 at 11:17 am
Lynn Pettis (9/19/2012)
Stefan Krzywicki (9/19/2012)
SQLRNNR (9/19/2012)
Grant Fritchey (9/19/2012)
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4....
"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
September 19, 2012 at 9:27 am
SQLSACT (9/19/2012)
Grant Fritchey (9/19/2012)
SQLSACT (9/19/2012)
Grant Fritchey (9/18/2012)
"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
September 19, 2012 at 7:49 am
Brandie Tarvin (9/19/2012)
Grant Fritchey (9/19/2012)
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild...
"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
September 19, 2012 at 7:14 am
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize...
"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
September 19, 2012 at 6:48 am
I don't know your structure, but on a guess, I'd assume that you're actually looking at denormalized data. Can't you normalize the structure and then import the information into 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
September 19, 2012 at 5:00 am
SQLSACT (9/19/2012)
Grant Fritchey (9/18/2012)
"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
September 19, 2012 at 4:18 am
jasona.work (9/18/2012)
I just realized the subject of this thread is WRONG!
It's about the SQL in the City, in Chicago, I have NO idea where I came up with the Saturday...
"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
September 18, 2012 at 10:40 am
GilaMonster (9/18/2012)
In that case, pack beer. Good European beer, not American beer.
Careful there. We're not living twenty years in the past. These days, America has beer as good as Europe....
"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
September 18, 2012 at 10:39 am
jasona.work (9/18/2012)
Just realized that I will have to leave the rum at home...Sorry...
:crying:
Well it's a good thing I'm not speaking at SQL Saturday. Now, when I show up for SQL...
"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
September 18, 2012 at 9:47 am
Viewing 15 posts - 10,441 through 10,455 (of 22,224 total)