Viewing 15 posts - 5,371 through 5,385 (of 6,105 total)
Run an EXEC sp_who2 and that should tell you what SPIDs are accessing the database.
K. Brian Kelley
July 3, 2002 at 2:26 pm
Files != Tables.
Files as in the files for the underlying physical structure of the database (see CREATE DATABASE). For instance, it is entirely possible to have 1 data file and...
July 3, 2002 at 2:24 pm
It's not the SQL Engine which is behaving differently, it's the way Enterprise Manager is performing actions. Best way to test is to start up Profiler. Run the test using...
July 3, 2002 at 11:50 am
DBCC INPUTBUFFER() will give you the last statement executed.
or use Profiler to capture statements as they happen.
K. Brian Kelley
July 3, 2002 at 11:48 am
This is one way:
SELECT E.EmpNo, E.EmpDate, E.Shift
FROM Emp E
JOIN (SELECT EmpNo, MAX(EmpDate) EmpDate
FROM Emp
GROUP BY EmpNo) E2
ON E.EmpNo = E2.EmpNo
AND E.EmpDate = E2.EmpDate
K. Brian...
July 3, 2002 at 8:24 am
Enterprise Manager goes through the following steps:
1) Creates a new table without the IDENTITY property on the column
2) Copies the data to the new table via an INSERT statement
3) Drops...
July 3, 2002 at 8:07 am
If I am understanding your requirements...
SELECT P2.shortsku
FROM tblProduct P1
JOIN tblKit K1 ON P1.edp = K1.kitedp
JOIN tblProduct P2 ON K1.componentedp = P2.edp
WHERE P1.shortsku...
July 2, 2002 at 9:19 pm
Clustered Index Scan = Table Scan (just against a clustered data structure as opposed to a heap structure).
Clustered Index Seek is where it's only hitting part of the overall...
July 2, 2002 at 9:16 pm
Yes, using NOLOCK may result in the query reading in uncommitted data. If you are reusing those values for other stored procs, you may indeed run into an issue.
K. Brian...
July 2, 2002 at 12:58 pm
What is the requirement for edp (I'm assuming that's what you meant)?
quote:
i need to get all records from tblkit where ed and...
July 2, 2002 at 12:56 pm
MTS handles all transactions, yes. However, it, by default sets transactions and sets them as SERIALIZABLE:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q215520
K. Brian Kelley
July 2, 2002 at 12:27 pm
What do the numbers on your buffer cache hit ratio and pages/sec look like?
K. Brian Kelley
July 2, 2002 at 12:17 pm
Take a look at the following Knowledge Base article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271509
One of the reasons the stored procedures may be holding locks on objects they don't touch is they are part of a...
July 2, 2002 at 11:43 am
Coding on the fly is generally a bad practice for any substantial effort. But I would see a good number of developers (including myself) do it for little bits of...
July 2, 2002 at 11:37 am
Viewing 15 posts - 5,371 through 5,385 (of 6,105 total)