Viewing 15 posts - 44,941 through 44,955 (of 49,552 total)
bhuvnesh.dogra (8/19/2008)
can anyone tell how " _" is being treated in LIKE keyword. ??
A couple people already have.
As I said, back in my reply to your first...
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
August 20, 2008 at 12:19 am
There aren't before triggers in SQL Server. Look up the Instead Of trigger in Books online for the other kind of trigger.
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
August 20, 2008 at 12:15 am
Here's a link to the other thread.
http://www.sqlservercentral.com/Forums/FindPost554864.aspx
Ashwin: It's prefered if you don't create multiple postings on the same subject, as it tends to result in people spending time answering questions...
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
August 19, 2008 at 3:43 pm
How are you viewing the number of work tables created? Perfmon?
Work tables are created by the query processor in order to process certain query constructs (sorts, hashes, I think spools,...
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
August 19, 2008 at 3:34 pm
Glad to hear you came right.
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
August 19, 2008 at 3:19 pm
@@Error is what you're looking for.
One thing to be careful of is that @@Error contains the status of the last statement. Every single statement within SQL (including things like...
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
August 19, 2008 at 10:14 am
The account that's used to start SQL isn't the one that SQL runs under. If you go into the SQL Server configuration manager you can set the account 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
August 19, 2008 at 5:56 am
Great. Can you post the table's create statement, the index definitions and the query itself please?
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
August 19, 2008 at 5:48 am
b_boy (8/19/2008)
Not able to attached execution query plans, file type not permitted
if you're using SQL 2005, right click the exec plan, choose save as. Save the file 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
August 19, 2008 at 5:21 am
Yes, and the index creation scripts would also be useful please.
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
August 19, 2008 at 4:55 am
gohsiauken (8/19/2008)
CREATE TRIGGER Product_tUpdateAfter800
on dbo.Product AFTER update
CREATE TRIGGER Product_tInsertAfter800
on dbo.Product AFTER Insert
CREATE TRIGGER Product_tIDeleteAfter800
on dbo.Product AFTER...
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
August 19, 2008 at 4:52 am
Shrink won't damage the database.
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
August 19, 2008 at 4:48 am
insert into Table1 (ConcatenatedColumn)
Select Col1 + ' ' + col2 + ' ' + col3 From SomeOtherTable
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
August 19, 2008 at 2:23 am
Are you looking for a report of how it looks now, or are you looking to capture changes?
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
August 19, 2008 at 2:01 am
But I need know how its work..Is it reducing the Log File Size
It reduces the size of the log file by releasing unused space within the file back to 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
August 19, 2008 at 1:43 am
Viewing 15 posts - 44,941 through 44,955 (of 49,552 total)