Viewing 15 posts - 31,876 through 31,890 (of 49,552 total)
shayy (7/12/2010)
2. about using the WHERE, what if i need let's say 10 fields, should i use the WHERE or just *?
??
The use of a WHERE clause limits the rows...
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
July 12, 2010 at 7:06 am
j_baldwinson (7/12/2010)
set @strSql = N'select @strFunctionResult = ' + isnull(@strRuleFunction, '')
+ '( ' + isnull('''' + @strOrderNo...
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
July 12, 2010 at 7:05 am
In the script that creates the trace, you can set the file size. If I recall, it's defined in a variable right at the beginning of the script.
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
July 12, 2010 at 7:02 am
shayy (7/12/2010)
Should i put a non-clustered index on the ProjectName?or i can just leave the default index from the PK on the ID field?
Do you have any queries that filter...
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
July 12, 2010 at 6:35 am
doobya (7/12/2010)
Index aware 'middle' value - Yes - I figured you can have a "loose binary search" that doesn't have to split the set exactly in two every time ...
I...
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
July 12, 2010 at 4:11 am
balaji.ganga (7/12/2010)
backup log databasename with truncate_only
That does not work in SQL 2008.
Msg 155, Level 15, State 1, Line 1
'truncate_only' is not a recognized BACKUP option.
If you don't want point-in-time recovery,...
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
July 12, 2010 at 3:12 am
doobya (7/12/2010)
When you look up a number in the phone book - you know whether to binary search left or right because the alphabet is increasing
You are aware that SQL...
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
July 12, 2010 at 3:09 am
What's Primavera?
Those errors aren't SQL errors, you're probably best off contacting the vendor, whoever supports the Primavera product and asking them.
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
July 12, 2010 at 2:33 am
Too many steps done in one go.
Firstly, query sys.databases, check what the value for state_desc is for this database. What is it.
Check the SQL error log. There WILL be entries...
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
July 12, 2010 at 2:16 am
azarcomp (7/12/2010)
I think the person who may hurtfull comments to me should be banned.
I don't see anyone been hurtful or nasty. I see a couple of direct, straightforward comments,...
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
July 12, 2010 at 2:14 am
lmu92 (7/11/2010)
CirquedeSQLeil (7/11/2010)
...Long live the vuvuzela!!!!!!!!!!!!!!
Would you repeat that face to face with Gail? (assuming she can hear you and doesn't still have that bee swarm sound in her ears...)
I...
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
July 11, 2010 at 11:49 pm
suresh kumar Sulakh (7/11/2010)
So one process waiting for another 🙂
No, that's blocking. Deadlock is two processes waiting for each other in such a way that neither will ever complete 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
July 11, 2010 at 11:49 pm
Don't use dynamic SQL in your triggers. Within dynamic SQL you can't see the inserted or deleted tables, you can't use the updated or columns_updated functions.
Rather use dynamic SQL 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
July 11, 2010 at 11:22 pm
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
July 11, 2010 at 11:21 pm
I don't believe you'll be able to do that while there's a log backup running, even if it's in rollback.
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
July 11, 2010 at 11:14 pm
Viewing 15 posts - 31,876 through 31,890 (of 49,552 total)