Viewing 15 posts - 48,121 through 48,135 (of 49,552 total)
If you want the data returned in a specific order, you need to add an order by clause. Data in a table is not considered in any particular order. In...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2007 at 4:28 am
The tran logs can be read, but they are not easy to understand and they don't contain information about people logging in and they don't keep info about who did...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2007 at 12:24 am
If you capture the event SP_StmtCompleted (under stored procedures), yes.
Profiler/SQL trace have massive numbers of events that can be traced. Just depends what you want to capture.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2007 at 12:15 am
If that was my table, I'd start by finding all the queries that refer to that table (profiler can help here), then in a dev environment, get a copy of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2007 at 12:11 am
Watch out for the simulations. They trip a lot of people up.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 4, 2007 at 12:01 am
montgomery johnson (12/3/2007)
When I query master..sysprocesses I only get 1 record.
You need view server state permissions to see anything other than your own connection. I assume you're not sysadmin.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2007 at 11:59 pm
Not many places. I've very very seldom needed a cross join. It's more common to have a cross join accidentily because of leaving out one or more join criteria.
Generally, if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2007 at 11:58 pm
Yup. Two windows (often I have more), replying to a post in more than one. Because of slow internet, I use multiple windows (at work) or multiple tabs (at home)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2007 at 11:46 pm
John Rowan (12/3/2007)
I was more referring to when someone posts a T-SQL question to the 2000 forum and the post gets answered with new 2005 stuff.
I'm usually careful with...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2007 at 11:45 pm
John Rowan (11/27/2007)
I agree in that I've read sooo many posts that were so badly presented that I simply move on to another.
Likewise. I only have so much...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2007 at 7:15 am
Or to do all the candidates in one go, rather than one at a time.
-- update where matched
UPDATE Candidates Set Candidates.Column1 = New_Candidates.Column1, ....
FROM New_Candidates
WHERE Candidates.Candidate_ID = New_Candidates.Candidate_ID
-- Insert...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2007 at 5:44 am
Jeff Moden (12/2/2007)
A
Why would you say that?
I'd say B. Dates should be stored in datetime columns, not seperated out. There are a couple of good reasons
There are some quite powerful...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2007 at 4:05 am
First I would suggest turning off the autoshrink. That will try and shrink both the data and the log files.
In simple recovery mode, the transaction log will grow to a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2007 at 1:21 am
They're in a different database to the one you're in. Look at the DB_ID.
If you're using SQL 2005 SP2, you can use the enhanced version on object_name that takes...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2007 at 12:33 am
karthikeyan (11/28/2007)
If you know answer then post it otherwise dont try to chear other persons.Understood.
Who gave you the right to order people around here?
And please lay off on the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 2, 2007 at 11:54 pm
Viewing 15 posts - 48,121 through 48,135 (of 49,552 total)