Viewing 15 posts - 39,361 through 39,375 (of 49,571 total)
Paul White (5/3/2009)
Michael Valentine Jones (5/2/2009)
As I have said all along, the OP will need to use separate databases to be able to restore data independently.
I don't agree. Here...
May 3, 2009 at 3:23 am
Paul White (5/1/2009)
And: Darn it - now I have to go and find out what a transportable thingy is in Oracle!
It allows for tablespaces (SQL filegroups) to be moved from...
May 2, 2009 at 11:52 am
RBarryYoung (5/1/2009)
The filegroups in a SQL Server database are not transactionaly independent and cannot be made to be so.
Correct. There is no way within the native SQL tools to...
May 2, 2009 at 11:44 am
ananda.murugesan (5/2/2009)
Thanks for your 's reply Steve & Gail..I should be disabled Re-organaize index page from maintenance plan.
Absolutely not. You need to be rebuilding your indexes on a regular...
May 2, 2009 at 3:50 am
select * from sys.types
select * from sys.database_principals
where type_desc = 'DATABASE_ROLE'
May 1, 2009 at 3:40 pm
Tao Klerks (5/1/2009)
GilaMonster (5/1/2009)
Short answer. UDFs are not considered 'inline'. If they're run in a query, the run once for each row.Long answer - http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/
Do you have a ready blog...
May 1, 2009 at 1:26 pm
Personally when I'm checking performance of queries, I just use the RPC:Completed and T-SQL Batch Completed events. The starting events give no useful information and I find they just clutter...
May 1, 2009 at 12:54 pm
Florian Reischl (5/1/2009)
Well, since even Steve didn't know this. Maybe these 3 persons have been the only...
Never noticed it either. I usually change the url directly if I want to...
May 1, 2009 at 12:27 pm
Tao Klerks (5/1/2009)
Does that make sense? Can a UDF really be that expensive?
Yes.
Short answer. UDFs are not considered 'inline'. If they're run in a query, the run once for...
May 1, 2009 at 12:22 pm
Part of this article goes over scripting a profile trace. I don't know why you want RPC:Starting. It's the competed events that have duration and other performance-related columns
May 1, 2009 at 11:11 am
jcrawf02 (5/1/2009)
Silly question, but you guys read any of the spinoff books by Kevin Anderson et al?
I've read quite a few. The Jedi Academy trilogy I found very good,...
May 1, 2009 at 11:08 am
No. Nor the version that casts to int.
DECLARE @Today2 DATETIME2 = GETDATE()
SELECT CAST(FLOOR(CAST (@Today2 AS FLOAT)) AS DATETIME2)
Msg 529, Level 16, State 2, Line 5
Explicit conversion from data type datetime2...
May 1, 2009 at 10:51 am
Ed (5/1/2009)
Using -3 millliseconds will give you the maximum time Sql Server can use.
True with datetime, but no longer true on SQL 2008 if you start messing with the higher...
May 1, 2009 at 9:41 am
nataliehinnen (5/1/2009)
I interpreted the email to mean that they plan on using different schemas for security reasons.... could that be it?
Could be, but again there's no logical reason hit to...
May 1, 2009 at 9:39 am
Viewing 15 posts - 39,361 through 39,375 (of 49,571 total)