Viewing 15 posts - 47,206 through 47,220 (of 49,571 total)
Any machine that has the SQL management tools on it (Management studio and the like) will have profiler. You can profile the server from any machine that can see it.
To...
March 13, 2008 at 12:53 am
Bracket in the wrong place. This passes a syntax check.
CREATE TRIGGER trg_PreventInvalidHours ON Works_On AFTER UPDATE AS
IF EXISTS (SELECT 1 FROM inserted i inner join deleted d
on i.ESSN =...
March 13, 2008 at 12:52 am
David Lester (3/12/2008)
Ok, so when executed a view gains a cached execution plan, which is reused, similar to a stored proc.
Any query that you run, whether you select from...
March 13, 2008 at 12:41 am
Then SSN is what the join needs to be on.
March 12, 2008 at 4:10 am
You can't have 2 primary keys on a table. If you mean it's a 2-column primary key, then you need to use both.
So:
inserted.ESSN = deleted.ESSN AND inserted.SSN = deleted.SSN
The point...
March 12, 2008 at 3:39 am
Mostly complete.
If you want to insert into an errors table, do it right after the rollback transaction. You can also use the raiserror to send an error back to the...
March 12, 2008 at 3:24 am
Try something like this. Untested. Please test carefully.
CREATE TRIGGER trg_PreventInvalidHours ON works_on AFTER UPDATE AS
IF EXISTS (
SELECT 1 FROM inserted i inner join deleted d on i.<Primary Key Column>...
March 12, 2008 at 3:04 am
There's some problem with the time zones I think. For me the time shows 11:18, but it's actually 10:18. My timezone is set to GMT + 2, no DST
March 12, 2008 at 2:20 am
Find your latest backup and restore it.
Based on the error, I would guess that page 126 holds part of one of the system tables. CheckDB canot fix a DB if...
March 12, 2008 at 2:16 am
For all queries SQL executes, the plans are cached and reused. Adhoc or procedures.
Views by themselves do not have execution plans. When a view is queried, SQL expannds the view...
March 12, 2008 at 2:00 am
The DAC connection will let you read the base system tables, not change them.
You cannot (and should not) change the system tables in sQL 2005.
What are yuo tryng to do?...
March 12, 2008 at 1:18 am
Did the service restart? Are there any errors in the SQL error log from around the same time?
March 12, 2008 at 1:13 am
If you have access to SQL Profiler, run it against the SQL server while testing out your web page. You'll be able to see if the delete, insert or update...
March 12, 2008 at 12:50 am
Does this help you? Cube and Rollup
Like many things in SQL, it probably has a performance impact, but if you need the summary rows it produces, then you need the...
March 12, 2008 at 12:42 am
Group by without a distinct has the same effect as DISTINCT. sometimes there are minor differences behid the scenes, but usually not.
When you use GROUP BY, you're telling SQL you...
March 12, 2008 at 12:22 am
Viewing 15 posts - 47,206 through 47,220 (of 49,571 total)