Viewing 15 posts - 39,976 through 39,990 (of 49,571 total)
select 'insert into exportacao_diferenca values ('+CAST(codctb AS VARCHAR(10))+','''+nifctb+''')' from TABELA_AUXILIAR_COMPARACAO
May I ask what you're trying to achieve here? There are easier ways to insert the values from one table into...
April 6, 2009 at 3:22 am
2cams (4/6/2009)
April 6, 2009 at 3:14 am
2cams (4/6/2009)
I create a NEW TRACE FILE when the server was idling @ 100% activity :hehe:
Ran the tuning advisor and it recomended 2 non clustered indexes. It...
April 6, 2009 at 3:03 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/Topic690756-148-1.aspx
April 6, 2009 at 1:03 am
pandeharsh (4/6/2009)
If i don't use group by or distinct,i get lot of records.
You've got duplicate rows because you've got a cross join. You have both table1 and table2 in the...
April 6, 2009 at 12:46 am
Achtang (4/5/2009)
with proper indexes or more memory?
Yes.
It depends where the problem is. If your indexing is not good, look to the indexes. If the indexes are good, add memory.
April 6, 2009 at 12:38 am
Achtang (4/5/2009)
do you set up Perfmon or SQL Trace?
As I said, Perfmon. SQL Trace won't tell you if you have an IO bottleneck. The disk counters within perfmon will...
April 5, 2009 at 2:02 pm
Achtang (4/5/2009)
you use dmv sys.dm_os_wait_stats and in this if you find many threads at PAGEIOLATCH then you can confirm that there is a problem with I/O subsystem
No.
If you find lots...
April 5, 2009 at 12:24 pm
It is possible to have excessive latch waits. Normally they fall into two categories:
1) Contention in TempDB
2) Slow IOs
Contention in TempDB
On SQL 2000 it was very likely, if TempDB was...
April 5, 2009 at 11:47 am
Latches are light-weight synchronisation constructs that are designed to protect the physical integrity of a page in a similar way to how locks protect the logical consistency of rows. They're...
April 5, 2009 at 11:04 am
This is a good place to start - http://msdn.microsoft.com/en-us/library/ms130764(SQL.90).aspx
April 5, 2009 at 3:54 am
Paul White (4/5/2009)
If the rule is unwritten then how was the OP supposed to be aware of it?
I never said they had to be aware of it. That comment was...
April 5, 2009 at 2:46 am
Got a backup? If so, restore that.
Are all the mdf files the same name? What's the modified date on the files? Do you have the ldf file as well?
April 5, 2009 at 2:37 am
tdhall_75233 (4/5/2009)
When trying to access from VS using C# the db is always in use when I try to access it.
How are you trying to access it? (C# code)
What...
April 5, 2009 at 2:00 am
Viewing 15 posts - 39,976 through 39,990 (of 49,571 total)