Viewing 15 posts - 46,756 through 46,770 (of 49,552 total)
ganesh.salpure (4/28/2008)
I have tried that..it does not workSELECT * , ROW_NUMBER ... as RowNumber
...
where RowNumber between 2 and 4
Well, obviously not as written. That's just the framework of 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
April 28, 2008 at 7:46 am
Last time I saw this it was due to really bad network connectivity between the publisher and the distributor.
Check your network, check the settings on the cards, check the available...
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
April 28, 2008 at 7:34 am
Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums
No replies to this thread please. Direct replies to the following thread...
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
April 28, 2008 at 7:33 am
Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums
No replies to this thread please. Direct replies to the following thread...
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
April 28, 2008 at 7:33 am
Perhaps something like this?
SELECT * , ROW_NUMBER ...
FROM
(SELECT empid1,name1,joindate from emp where empid2=3
union
select empid2,name2,joindate from emp where id1=3) sub
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
April 28, 2008 at 7:11 am
Can you please post the queries that are taking longer, as well as the delete statement.
Are you running SQL 2005? If so, please save the execution plan as a .sqlplan...
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
April 28, 2008 at 7:02 am
Great. There's just one thing I wanna know...
How fast was it?
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
April 25, 2008 at 5:35 am
Why don't you just put a unique constraint on the emp_id column? No need for a trigger at all.
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
April 25, 2008 at 3:56 am
Um, maybe trash the cursor and do it as a set-based update. Shouldn't take more than an hour...
Untested, because I don't have schema, sample data or expected output. Should be...
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
April 25, 2008 at 3:22 am
What part don't you understand?
When SQL uses a variable in a where clause it uses the contents of the variable as a literal value. Not as a reference 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
April 25, 2008 at 3:05 am
You need to add a linked server before you can use 4-part naming to refer to a remote machine.
If you're sysadmin, you shoul be able to do that yourself. Go...
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
April 25, 2008 at 12:22 am
Rollback segment?
That's an Oracle concept, not SQL server. SQL doesn't have rollback segments.
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
April 25, 2008 at 12:20 am
It's not a corruption message.
That's telling you that the OS ran short of memory (physical) and paged the SQL server process's working set to the swap file. It's pretty 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
April 25, 2008 at 12:06 am
Michael Earl (4/24/2008)
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
April 25, 2008 at 12:02 am
*steals soapbox*
And make sure that said backups are restorable. There's nothing worse that tellng management that 'Everything's fne, we have recent backups', then finding that said backups are not restorable
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
April 24, 2008 at 11:44 pm
Viewing 15 posts - 46,756 through 46,770 (of 49,552 total)