Forum Replies Created
Viewing 15 posts - 14,071 through 14,085 (of 22,224 total)
-
RE: Are the posted questions getting worse?
Brandie Tarvin (10/19/2010)
I would just like to let everyone know that I live very green.My sheets are green, my clothes are green, my food is green, my cats are green......
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Create Hidden Trace / Mask Trace
mitchismoney (10/19/2010)
The user doesn't have access to profiler. Will revoking access to trace work even DBCC Traceon? I didn't think you could deny specific DBCC commands?Thanks
You can't deny...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How to get the Internal ID from a ROW
This is not something I've tried before. When I tried to replicate what you said happens, with duplicate rows and editing them using SSMS, I got this error:
This is a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Maintenance Plans in SQL 2005
Brandie, EXCELLENT point on testing backups. That is something we do, but I forgot to mention it. It's a must.
Just a side note, a Microsoft consultant told me that all...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Urgent SQL Linked Server Query - Cannot see ms access linked tables.
If you can't see the tables, it's probably a security issue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL Database monitor : How?
I don't know what the Plesky software is, so I can't help there.
If you can't run performance monitor on the server, but you are still interested in getting some of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Create Hidden Trace / Mask Trace
If you just take away their trace permissions on the server, they'll never know. Do they currently use trace? If not, they'll never miss those privs. If so, there's little...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Affected tables in DB
MpriorJ (10/19/2010)
Thank you for the help so far, i will try to trace the changes. This will be my first time. 🙂My idea was to use the application, by entering...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (10/19/2010)
Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-1.aspxTossed in a penny. Let's hope it helps.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Maintenance Plans in SQL 2005
The name "Maintenance Plan" pretty much defines what you're going to be building. A set of routines for maintaining your database and server. This is not the same thing as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (10/18/2010)
Craig Farrell (10/18/2010)
To go back to our earlier discussion on bad drivers in random places, apparently hit'n'runs are universal.I nearly got side-swiped into a concrete barrier this...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Lynn Pettis (10/17/2010)
Sorry, but I couldn't resist responding. We'll see how he takes my critizism (sp ?).Oh hell, I posted. If he goes off on it or whatever, I'm...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL SERVER 2000 Retrieve Data using IntMth n intYear Parameter
Developers may not want to use stored procedures, I get it, but you should at least use parameterized queries. This avoids T-SQL injection and will lead to plan reuse. This...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Start your ignition to Production
Anamika (10/17/2010)
Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?
On memory utilization, space, Performance...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are There That Many GUIDs?
Jeff Moden (10/17/2010)
Grant Fritchey (10/12/2010)
They should be used where appropriate...I apologize for puting you on the spot but what do you consider an appropriate use for them is especially since...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 14,071 through 14,085 (of 22,224 total)