Viewing 15 posts - 48,721 through 48,735 (of 49,571 total)
Couple problems here. The first, and the one that you're noticing is that you don't do comparisons to NULL using = or !=. The rules of NULL comparisons say that...
May 8, 2007 at 3:59 am
Can you be a little more specific about what you're trying?
In general, for performance question, my first answer is 'try both and see which is better'
May 8, 2007 at 3:17 am
Then all you're looking for is a simple, one row insert.
When the user registers fire off a stored proc that just inserts that userID into your custom table.
CREATE procedure [dbo].[getcustomProfile]
@UserId...
May 8, 2007 at 12:15 am
First thing, remove that cursor. It's not necessary. This will do exactly the same as that entire cursor.
INSERT dbo.custom_Profile (UserId
May 7, 2007 at 4:46 am
Only by doing it the way management studio does, by creating a new table, copying the data over and dropping the old column.
Have you tried Alter Table Alter Column? I...
May 7, 2007 at 2:35 am
If you have an index on a column, you will always have statistics on that column as well. They will be updated automatically from time to time.
You can create statistics...
May 7, 2007 at 2:15 am
Ah, sorry fot the misread. Yeah, that's fine.
May 4, 2007 at 12:17 am
a) recompiles (MANY more than you might suspect, since IIRC for every 6 rows you insert/modify, the code referencing the temp table will be recompiled). This gets expensive.
Plus every time...
May 3, 2007 at 7:13 am
It's still getting updated with each insert and you could be see a lot of thrash on the system from it reorganizing to ensure that it's at 100%.
Fill factor...
May 3, 2007 at 2:20 am
Processes blocking themselves is not a problem. It happens when a process parallels and then has to wait for one of the spawned threads to merge the threads.
Regarding the deadlock,...
May 2, 2007 at 8:07 am
Try this
SELECT ...
From ScoutingReport as sr
Join Person as p on p.Id = sr.ScoutedPersonID
April 25, 2007 at 2:12 am
SELECT * FROM tbl WHERE col not like 'ABC%' and COL not like 'DEF%'
April 24, 2007 at 2:19 am
Restore a backup, restore the tran logs and stop just before the 'drop'
Then you can find whoever wrote that code and give then a good wack upside the head for...
April 24, 2007 at 12:17 am
It's highly unlikely to see much of a change in speed for a data type change.
If you haven't rebuilt the clustered index, then the data will still occupy the...
April 23, 2007 at 12:50 am
Viewing 15 posts - 48,721 through 48,735 (of 49,571 total)