Viewing 15 posts - 41,491 through 41,505 (of 49,552 total)
JKSQL (1/22/2009)
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
January 22, 2009 at 10:24 am
ashepard (1/22/2009)
The "in-memory result set" - is that a table ?
Depends on your definition of table.
Do you refer to the output of a query as a table? 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
January 22, 2009 at 9:47 am
gyessql (1/22/2009)
select ...
from table t1
inner join t2
...
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
January 22, 2009 at 9:24 am
gyessql (1/22/2009)
Does this mean, instead of ON and AND, for readability ON and ON can be used?
No. They're not synonymous.
select ....
from ....
...
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
January 22, 2009 at 9:00 am
Bob Hovious (1/22/2009)
Grant, would you mind showing an example of how you would use joins in a where clause? I'm not sure what you mean.
Well, it's not 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
January 22, 2009 at 8:52 am
DBADave (1/22/2009)
Another statement they made in the doc is that we should identify the code causing the deadlocks and add indexes if necessary to resolve the problem.
Other problem...
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
January 22, 2009 at 7:59 am
Please post new questions in a new thread (in an appropriate forum) as people may miss it at the end of an existing thread, and SSIS people may well not...
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
January 22, 2009 at 7:58 am
So cast the uniqueidentifier to a varchar before concatenating.
Why do you have denormalised tables? What's the reason for putting lists into a single column instead of into a child table...
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
January 22, 2009 at 7:31 am
ashepard (1/22/2009)
Hi. Yes there is a temporary internal table for the resultant set rows that the cursor runs against I believe
That's cursors. Not general queries
For general queries,...
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
January 22, 2009 at 7:28 am
Nothing in the SQL error log 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
January 22, 2009 at 7:12 am
Lowell (1/21/2009)
really, i think there are only like 6 questions that keep getting repeated over 90 percent of the posts, and the other 10% are the ones that we enjoy.
You...
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
January 22, 2009 at 7:00 am
DBADave (1/22/2009)
Deadlocks can frequently occur on SQL Server 2005 as SQL Server 2005 place locks on the page level rather than row levelDo you agree with this statement?
No.
All versions...
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
January 22, 2009 at 6:52 am
In addition, an administrator could put a packet sniffer in place and read all of the network packets coming into the server. Unless you've got those encrypted, that'll reveal...
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
January 22, 2009 at 6:39 am
Great. Now give some though to good log management so that this won't happen in the future.
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
January 22, 2009 at 6:36 am
onlyvikas2004 (1/22/2009)
that means no way to restrict sysadmin at all? :crying:
No. That's the definition of 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
January 22, 2009 at 6:15 am
Viewing 15 posts - 41,491 through 41,505 (of 49,552 total)