Viewing 15 posts - 48,871 through 48,885 (of 49,566 total)
Or for two columns and one row. Untested, but should work.
SELECT Status, SUM(CASE Copies WHEN 0 THEN 1 ELSE 0 END) AS CountCopies0, SUM(CASE Copies WHEN 1 THEN 1 ELSE 0...
January 23, 2007 at 1:22 am
Interesting stories
I was born in Burmingham in England, but moved to South Africa with my parents when I was very young. Other than four years at university in Grahamstown (1000km...
January 22, 2007 at 6:24 am
If the clustered index is on the GUID, you can get an improvement by rebuilding the clustered index, as it's probably badly fragmented. Once the index is rebuild you should...
January 22, 2007 at 5:47 am
Answered here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=338509
Please don't cross-post, we do see all new posts to all forums.
Thanks
January 22, 2007 at 5:11 am
Non-clustered indexes on a heap table point to the data using the RID, because there's no alternative. So, why do others use the clustered index instead of the more direct...
January 22, 2007 at 4:46 am
A non clustered index only has in it the values of the columns contained within the index. It dosn't have the rest of the row. If ta query is done...
January 22, 2007 at 4:34 am
Check to see if it is SQL that's taking the CPU. There shouldn't be anything else running on a SQL Server, but is worth checking. Use task manager for this.
Rebuild...
January 19, 2007 at 4:10 am
First things, since you shrank the database. Grow it back to a reasonable size and rebuild all the indexes. Shrinking a database shuffles data pages around, fragmenting indexes very very...
January 19, 2007 at 1:14 am
Create a 2 column unique index. While there can only be one pimary key on a table, there can be multiple indexes.
CREATE UNIQUE INDEX idx_MyTable_EmailPassword
ON MyTable (email, Password)
Trigger will work,...
January 19, 2007 at 12:43 am
Be aware that your solution won't handle cases where multiple rows are inserted in a single batch. Your trigger will only get one of the inserted rows.
January 17, 2007 at 11:00 pm
If means that on your production server the query is reading more data pages, either from memory or disk, than on the dev server.
There shouldn't be much disk activity on...
January 16, 2007 at 4:05 am
This is from memory, cause I don't have a SQL 2000 server here.
In enterprise manager, expand out the server. Select management (I think) expand out and you'll see entries for...
January 16, 2007 at 4:03 am
Don't shrink a DB after a reindex. You're just undoing all the work that reindex did.
If you absolutely have to, make sure that you use the TRUNCATEONLY clause, to just...
January 16, 2007 at 3:52 am
Check your disks. Sounds like you may have IO throughput problems
I had latch waits on one of my databases some months back. We traced it down to very slow SAN...
January 16, 2007 at 3:46 am
Pleasure
Will you let me know if that is the case?
Easiest way to check if there are triing spaces is a query like
select '[' + TheVarcharColumn + ']' from TheTable
then you...
January 14, 2007 at 10:29 am
Viewing 15 posts - 48,871 through 48,885 (of 49,566 total)