Viewing 15 posts - 40,756 through 40,770 (of 49,571 total)
Fraggle (2/26/2009)
If that is the case and I am getting a filter on column 6, then why does the exection plan say
Index Seek -> Select
with no filter or...
February 26, 2009 at 9:29 am
cshekhar (2/26/2009)
February 26, 2009 at 9:24 am
Please post in an appropriate forum in the future. The article discussion forums are for discussions on articles.
Google will give you links to quite a few apps that can...
February 26, 2009 at 9:20 am
aks_pra (2/26/2009)
I wanted to Attached database without LDF file.B’coz my LDF size is greater than the MDF
That is a very, very bad way of handling a large transaction log....
February 26, 2009 at 9:16 am
robert.larsson (2/26/2009)
Just as i expected but my boss wouldnt take that as an answer =) "keep finding a way to verify if the backup is corrupted or not".
That's what RESTORE...
February 26, 2009 at 9:15 am
sqlserverdba.dba (2/26/2009)
Are you refering to Perfmon?
No. Perfmon is a windows tool. I'm referring to SQL Profiler and the stored procs that it uses.
If not then please provide me the...
February 26, 2009 at 9:09 am
Fraggle (2/26/2009)
However, this is not the case. I do get an index seek with INDEX1.
What you're getting is a seek on column1 followed by a filter on...
February 26, 2009 at 9:05 am
Fraggle (2/26/2009)
So if I searched by column, 1, 2, 3, & 4, I could essentially create 4 indexes as follows and I should get seeks on all of them?
Yes, for...
February 26, 2009 at 9:03 am
All the info you need is here. http://www.microsoft.com/learning/mcp/certifications.mspx
The self-paced training kits are quite good.
February 26, 2009 at 1:42 am
ray.gabriel (2/25/2009)
EXECUTE IMMEDIATE
That doesn't look like T-SQL.
If it is T-SQL, checks are done like this
IF EXISTS (SELECT 1 from sys.objects where name = 'CUSTOMER_RICH_CONTACTS_RO1')
ALTER TABLE MCCOYS.CUSTOMER_RICH_CONTACTS DROP...
February 26, 2009 at 1:30 am
1000 page is the usual rule-of-thumb. Smaller than that and the table will probably be in memory. Fragmentation is a disk issue, it doesn't affect pages in memory.
The other thing...
February 26, 2009 at 1:27 am
prinztelly (2/25/2009)
February 26, 2009 at 1:23 am
This is a forum, not a chat room. Be patient.
On SQL 2000, the only way to get all DDL and DML statements is to use a trace. Not profiler, too...
February 26, 2009 at 1:21 am
DDL triggers were introduced in 2005. There's no equivalent feature in SQL 2000
February 26, 2009 at 1:16 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic664825-391-1.aspx
February 26, 2009 at 1:12 am
Viewing 15 posts - 40,756 through 40,770 (of 49,571 total)