Viewing 15 posts - 43,606 through 43,620 (of 49,571 total)
fjmorales (10/22/2008)
October 24, 2008 at 4:17 am
Yup, and you should test any recommendations out on a dev system to be sure that they really do help. Also check the recommendations to see if there's an existing...
October 24, 2008 at 4:12 am
You may want to run a full checkDB on that database to be sure there's no more corruption. From the looks of things, that error can be fixed by dropping...
October 24, 2008 at 4:04 am
That a a syntax error from the dynamic SQL. Print the SQL before you exec it and you should be able to see exactly what gave the error and what's...
October 24, 2008 at 4:02 am
Performance testing code before deploying to production.
I got very tired of devs deploying code to prod without doing any form of performance testing on it. The code frequently performed terribly...
October 24, 2008 at 4:01 am
Interesting. All of the branches are the same spid. I think this is a parallelism deadlock. Did you read the blog post I linked above?
Other thing to note is that...
October 24, 2008 at 3:27 am
victor_bosc (10/23/2008)
I think that I have a problem with the full backups because the backup process used to take between 45 and 60 minutes.Now, it is taking between 2 and...
October 24, 2008 at 3:14 am
john (10/23/2008)
Yes I would love to learn how to write it better but I am still a noob and learning.
Best practice - all data access via stored procedures. Parametrise the...
October 24, 2008 at 3:09 am
I'm guessing that it's because the alias to the first table is missing
sqlString.Append("SELECT m.ID as displayID, isnull(fname,lastname) + " + "' " + "' " + " + lastname as...
October 23, 2008 at 3:04 pm
Maqsood Ahmad (10/23/2008)
DBCC CHECKDB('AlarmSwitch') WITH NO_INFOMSGS
It took about 3 minutes and then I got message 'Command(s) completed successfully.'
Its mean there is no problem with my...
October 23, 2008 at 2:58 pm
victor_bosc (10/23/2008)
The transaction log backup backups the log, but it does not free the space to the operating system. And the shrinkfile release the space.
Correct. However you don't want to...
October 23, 2008 at 2:09 pm
Maqsood Ahmad (10/23/2008)
I understand that in SQL Server 2005 we can't update it but because we have migrated our application from SQL Server 2000 to 2005...
October 23, 2008 at 1:58 pm
Maqsood Ahmad (10/23/2008)
Through some how I want to change system catalog (syscolumns table)In syscolumns table there is a column "colid" I want to change the value of this colid.
Nope....
October 23, 2008 at 1:45 pm
Try the DATEPART and DATENAME functions
October 23, 2008 at 12:34 pm
NULL is not like anything and NULL is not not like anything. A comparison with null (other than IS NULL or IS NOT NULL) will never return true.
http://sqlinthewild.co.za/index.php/2008/01/16/comparisons-with-null/
October 23, 2008 at 12:33 pm
Viewing 15 posts - 43,606 through 43,620 (of 49,571 total)