Viewing 15 posts - 41,161 through 41,175 (of 49,571 total)
GSquared (2/10/2009)
Bruce W Cassidy (2/9/2009)
February 10, 2009 at 8:15 am
viduvs (2/8/2009)
This stored procedure uses cursor to perform this data migration.
That's possibly one of the reasons for the slowness. Why a cursor?
February 9, 2009 at 1:28 pm
Gunjan (2/9/2009)
Yes. That's what I have used to consume WCF service.
Why?
SQL is a database engine, not an application server. Why is the database calling WCF services?
February 9, 2009 at 1:25 pm
Vijaya Kadiyala (2/9/2009)
What if the table already exists, so in this case we have to use Update Statement right!!
Why?
Alter Table Add .... and add the computed column to the...
February 9, 2009 at 1:21 pm
The file that you're trying to restore (which looks like an mdf file) is not a valid backup.
Can you explain more what you're trying to do, with what files and...
February 9, 2009 at 11:00 am
saby (2/9/2009)
add more tempdb files
TempDB is database ID 2, not database ID 6
samsql: Are you getting latch waits? What's happening at the time? Can you post full message if there's...
February 9, 2009 at 10:55 am
terryj30 (2/9/2009)
I really wound not recomend this but it will create you a new tranlog that is empty.
I would not recommend that under any circumstances. It's the quickest way...
February 9, 2009 at 10:50 am
Depends on the type of crash. If the tran log is still available and SQL is still running, then you can take a tail-log backup (see books online for details,...
February 9, 2009 at 10:48 am
gyessql (2/9/2009)
I am a little confused. The first part says to use local variables, the second part says using parameters is better than local variables. Which is better?
I don't...
February 9, 2009 at 10:39 am
ALZDBA (2/9/2009)
I know it should do the same as between, but I've read somewhere datetimes and between did cause some issues.(Although I haven't got an url available)
It will run the...
February 9, 2009 at 10:32 am
DavidB (2/9/2009)
Ratheesh.K.Nair (2/9/2009)
I have run some update statistics and index reorganize commands but they are not shown in SQL Server logs.
Have you seen somewhere that these are logged events? I...
February 9, 2009 at 10:28 am
jmazzolini (2/9/2009)
Does anyone have any suggestions? I am looking for high quallity training with experienced people...more than simple test preparation.
Where in the world are you?
February 9, 2009 at 10:15 am
Not unless there was a profiler trace running
February 9, 2009 at 10:14 am
trans54 (2/8/2009)
How about the order of the INCLUDE? Does it matter in this case?
As I said in the post above
and order of include columns doesn't matter because they are only...
February 9, 2009 at 10:09 am
ankur.bhargava (2/9/2009)
Hi All,Thanks for your replies. Below is the stored procedure which I am running.
What, at a high level, is it supposed to do?
Microsoft SQL Server 2005 - 9.00.1399.06...
February 9, 2009 at 10:06 am
Viewing 15 posts - 41,161 through 41,175 (of 49,571 total)