Viewing 15 posts - 8,131 through 8,145 (of 22,224 total)
Either google-fu is failing me or I'm delusional about the recording of the discussion (both possible). Sorry.
"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
May 15, 2014 at 10:03 am
No, i'm sorry Stefan, I don't have a specific resource on that one. It's something that came out of multiple talks with Oracle people to get an understanding of what...
"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
May 15, 2014 at 10:00 am
To a degree, what people think of as cursors in Oracle (and maybe in other DBMS, I'm not sure) are two things, one of which we have in SQL Server....
"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
May 15, 2014 at 9:34 am
Assuming TableA is the parent to TableB and that's the parent to TableC, then your delete order should be:
TableC
TAbleB
TableA
If you try anything else, you'll get referential constraint errors, as 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
May 15, 2014 at 7:15 am
Data can be cached on the servers outside SQL Server, then the queries against SQL Server won't ever show that data. But that's the only thing I can think 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
May 15, 2014 at 5:47 am
isuckatsql (5/15/2014)
"By the way, just we're clear, dbo.cb is an indexed view? What's the key value on?"dbo.cb is a Table not am Indexed View.
The primary key is ID.
Thanks
Then where are...
"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
May 15, 2014 at 5:44 am
You can get some idea of what's accessing it by querying sys.dm_exec_query_stats and combining that with sys.dm_exec_sql_text and looking for your particular table. But, that's only going to show the...
"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
May 15, 2014 at 4:51 am
And don't use the Profiler gui against a production server. It can add to your problems because it buffers data in a different way than server-side trace.
"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
May 15, 2014 at 4:47 am
Sure, the duration in SSMS includes the time it takes to move the query and the results across the network. Trace and extended events just measure the time it takes...
"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
May 15, 2014 at 4:46 am
mssqlsrv (5/15/2014)
I am doing the rebuild process once only.If I don't drop the views and indexes which are schema bound to table,
Will that affect my insert statements on table?
Yes, 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
May 15, 2014 at 4:34 am
Koen Verbeeck (5/15/2014)
Grant Fritchey (5/14/2014)
... So, if you need to have a mixed access table, ....
What do you mean with this?
The table becomes read-only, so you can access it only...
"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
May 15, 2014 at 4:33 am
I'm a little confused. Let's verify that backups work. Can you run something like this from your T-SQL window in SQL Server Management Studio:
BACKUP DATABASE yourdbname
TO DISK = 'x:\yourdriveandlocation.bak'
WITH INIT,...
"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
May 14, 2014 at 7:22 pm
isuckatsql (5/14/2014)
http://www.statisticsparser.com/Is this good enough?
Ha! Well that is one way to do it I suppose.
You're still dealing with the fact that some of the time you're seeing is just because...
"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
May 14, 2014 at 5:08 pm
Oh, and welcome to SQL Server Central. We try to provide a nice, helpful place around here. If you ever get attitude from anyone, let me know.
"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
May 14, 2014 at 3:39 pm
This web site [/url]does a nice job of summarizing the differences between the two. The big difference is that mirroring actually provides an automated stand by situation where the mirror...
"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
May 14, 2014 at 3:38 pm
Viewing 15 posts - 8,131 through 8,145 (of 22,224 total)