Viewing 15 posts - 43,681 through 43,695 (of 49,552 total)
Duplicate post.
No replies to this please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic588085-149-1.aspx
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
October 18, 2008 at 3:19 am
They're used to do row-by-row processing. In general, that's a very poor way to do things in SQL, as the database engine works better on sets to rows than multiple...
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
October 18, 2008 at 3:18 am
What do you want to do with said trigger and why do you have to use CLR?
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
October 18, 2008 at 3:16 am
Um, can you maybe give a bit more info? What do the tables look like? What are the foreign key definitions? What are you deleting?
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
October 18, 2008 at 3:14 am
2.Rebuild Index [Expect System Database]
3.Shrink Database [Expect System Database]
That's a combination I generally refer to as a waste of time. The shrink will cause massive fragmentation of your indexes, easily...
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
October 18, 2008 at 3:08 am
danschl (10/17/2008)
sql2008 is sql2005 sp3
There definitely is a SP3 for SQL 2005 on its way
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
October 17, 2008 at 3:57 pm
In my opinion, guest should have no rights at all in the DB. Logins that need access to the DB should be granted access and have the exact permissions they...
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
October 17, 2008 at 2:13 pm
Doesn't matter what database it's 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
October 17, 2008 at 10:08 am
What's the question?
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
October 17, 2008 at 10:06 am
That's a display issue, not a data issue. That kind of thing should be done in your application/report, not in the database.
You can set the grouping levels in the report...
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
October 17, 2008 at 10:00 am
You may want to set the end time to be an offset of the time the script runs. Something like
SET @DateTime = DATEADD(hr,1,GETDATE())
if you want the trace to run...
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
October 17, 2008 at 9:59 am
arbarnhart (10/17/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
October 17, 2008 at 9:46 am
Get profiler to script the trace. (File - Export). Put the script in a SQL job, make the couple of required changes (specifying a filename and the end time) and...
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
October 17, 2008 at 9:13 am
And please don't post in all caps. It's the online equivalent of shouting at someone. It's also hard to read.
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
October 17, 2008 at 9:09 am
Do you have speed problems with the queries from your application, or do you just have speed problems with browsing the metadata in management studio?
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
October 17, 2008 at 9:07 am
Viewing 15 posts - 43,681 through 43,695 (of 49,552 total)