Viewing 15 posts - 1,561 through 1,575 (of 5,504 total)
You might want to have a look at the first article referenced in my signature for a guide on how to post ready to use sample data.
May 15, 2011 at 3:46 pm
As a more general answer you might want to have a look at Gails blog[/url] regarding left outer join vs not exists. 😉
May 15, 2011 at 3:11 pm
Please provide the actual execution plan as an attached sqlplan file. Maybe additional/different indexing will help.
May 15, 2011 at 2:46 pm
Which one provides the correct results?
May 15, 2011 at 1:31 pm
Welsh Corgi (5/15/2011)
Marc Bizzar (5/15/2011)
"I'd guess the connection is closed and reopened leading to the temp table getting deleted in between."
Perhaps I'm not understanding you correctly but the issue...
May 15, 2011 at 11:58 am
Sounds like mirroring with a dedicated witness server (see BOL, section "Overview of Database Mirroring").
May 15, 2011 at 11:48 am
Like I said before: I recommend to get a consultant in for a day or two. It'll be much more efficient than using a forum. Based on the information currently...
May 15, 2011 at 7:51 am
A local temp table is valid as long as the original connection exists and is visible to their creator. It is also possible to apply DML statements as long as...
May 15, 2011 at 7:46 am
You could use a WINDOWS scheduled task calling a bcp out command with a trusted connection.
Regarding details for bcp please see BOL (BooksOnLine, the SQL Server help syste usually installed...
May 15, 2011 at 5:31 am
No.
The first one will return more rows since you'll get rows returned on the left side of your join regardless whether t2.col2 is null or not.
The second query will exclude...
May 15, 2011 at 5:22 am
The issue is caused by your variable assignment. This will only affect rows that meet one criteria.
Try the following instead:
CREATE TRIGGER [dbo].[trg_LogStatus]
ON [dbo].[Waybills]
AFTER INSERT,UPDATE
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO [dbo].[WaybillStatuses]
([WaybillId] ,[StatusId] ,[StatusDate]...
May 15, 2011 at 4:56 am
If you don't know the relationship of the data, ask the person providing it or ask someone in your organization to explain the business case you're dealing with. It might...
May 15, 2011 at 3:42 am
Even if Because of he's your best friend you should not jeopardize his business software. Friendship is a personal relationship. Changing software his business might rely on is purely a...
May 14, 2011 at 4:54 am
Please provide table def a nd sample data in a ready to use format together with your expected results (see the first link in my signature for an example).
I'm sure...
May 13, 2011 at 1:13 pm
chandan_jha18 (5/13/2011)
Thanks. I started with backup and restores and then moved on high end DBA tasks. Gradually i started to read and understand t-sql but not on a level...
May 13, 2011 at 11:55 am
Viewing 15 posts - 1,561 through 1,575 (of 5,504 total)