Viewing 15 posts - 2,806 through 2,820 (of 3,232 total)
Run DBCC CHECKDB against the database. Correct any errors that it reports (by using the repair option). If this does not report any errors, it is most likely an intermitant...
June 27, 2006 at 11:47 am
It is OK as far as the data type that you use. This is one of the limitations of using Identity columns, they only last as long as the datatype. ...
June 27, 2006 at 10:18 am
As Robert said, look in BOL for information on how to implement locking hints.
It is important to point out that using a locking hint is like giving SQL Server...
June 27, 2006 at 10:01 am
I don't think this is going to cause you any problems from a performance standpoint; EM should just be executing an INSERT statement behind-the-scenes. Try running profiler and capturing what...
June 27, 2006 at 9:39 am
I am not quite clear on what you are after here, but from a quick glance, you need to check your join columns. Why are you joining on branchID only? ...
June 26, 2006 at 3:44 pm
The constraint error that you are getting is telling you that you are trying to insert an invalid GroupID into your UserGroups table. The GroupID does not exist in your...
June 26, 2006 at 3:36 pm
Collation can be set at multiple levels in SQL Server. You can set Collation at the instance, database, or object level. From what I am seeing from your post, your...
June 26, 2006 at 2:50 pm
Well, there are many tools and methods that you can use to look at SQL Server performance. There are many performance related articles on SSC and also on http://www.SQLServerPerformance.com. Much of...
June 26, 2006 at 1:38 pm
There is no TSQL command to make the DELETE statement in your query perform a cascaded delete. You would need to write 2 DELETE statements in your query. The first...
June 26, 2006 at 1:01 pm
"The reason I ask is because putting the main database on the RAID really seems...."
When you say 'main database', I assume that you mean the 14 GB DB with your...
June 23, 2006 at 9:42 am
You are correct, you cannot use a variable with TOP. Try this instead:
DECLARE @TopCnt int
SET @TopCnt = 100
SET ROWCOUNT @TopCnt
INSERT INTO #B
SELECT *
FROM #A
SET ROWCOUNT 0 --Make sure you...
June 23, 2006 at 9:01 am
Yes, it is rebuilding all non-clustered indexes on the table. The clustered index key is part of all non-clustered indexes on a table where both exist, so any time you...
June 23, 2006 at 8:50 am
Have you looked in EM to make sure that sp_dboption is missing from your Master DB? You may want to try running sp_dboption again, but fully qualifying the SP name...
June 22, 2006 at 4:10 pm
SELECT MAX(DeliveryDate), Product FROM YourTable GROUP BY Product
June 20, 2006 at 9:57 am
I just realized that I pasted the wrong section into my post.
This returns the same result as Brendt's DatePart/Cast example, but with less function calls:
SELECT CONVERT(varchar,GETDATE(),112)
June 19, 2006 at 2:53 pm
Viewing 15 posts - 2,806 through 2,820 (of 3,232 total)