Viewing 15 posts - 6,556 through 6,570 (of 7,413 total)
is there something in the join that could be counting these records out?
Maybe in some cases "s.[to Date of service]" is NULL to indicate "no end date"?
February 22, 2013 at 11:33 am
You need to do mirroring at the disk level, not the database level. The number of databases is then irrelevent, it's only the total volume of changes that is...
February 22, 2013 at 11:28 am
If you can accept the total stand-alone in a different result set, you can add this:
COMPUTE SUM(acres) --but will NOT work in SQL 2012!
to your query.
February 22, 2013 at 11:21 am
Alexander Suprun (2/21/2013)
ScottPletcher (2/21/2013)
February 21, 2013 at 3:12 pm
Did you try just putting the Status column only in the index? SQL can still use that index to do a key lookup back to the main table. ...
February 21, 2013 at 1:22 pm
Is CASTing cost an additional overhead to the query?
In this case, no. In fact, here it might actually help ever so slightly.
SQL has to determine a datatype for...
February 21, 2013 at 10:08 am
Are Transaction_Numbers -- i.e. clustered key values -- added in ascending sequence?
If so, make sure SQL is sorting the rows before doing the INSERTs.
If not, and you're sure you have...
February 21, 2013 at 10:05 am
bangsql (2/21/2013)
1. any query uses group by , order by etc.. uses tempdb.so if view contains that tempdb will use
2. no of physical cpu = no of tempdb files.
RAM...
February 21, 2013 at 10:02 am
1) I know temporary tables and table variables occupy space in TempDB, but what happens when I invoke a view; do views also make demands on TempDB?
2) What is the...
February 21, 2013 at 9:59 am
I support the idea of using CONTEXT_INFO for this.
But I'd suggest limiting the use of it to a single, predefined byte location. And also not destroying any unused in...
February 19, 2013 at 5:59 pm
The "instead of" trigger will fire first.
If the "instead of" trigger does actually insert a row(s), then the "after[for] trigger" will fire.
You may want to use the clearer "AFTER INSERT"...
February 19, 2013 at 5:21 pm
Jeff Moden (2/19/2013)
ScottPletcher (2/18/2013)
Jeff Moden (2/18/2013)
ScottPletcher (2/18/2013)
declare @enddate datetime
set @enddate = getdate()
SELECT STUFF(CONVERT(varchar(10), DATEADD(DAY, -21, @enddate), 1), 3, 4, '')
Except for Sean, we did forget to answer the original question....
February 19, 2013 at 10:16 am
Jason-299789 (2/19/2013)
I would disagree with you on the under no circumstances comment, for a couple of reasons
1) the risk of fragmentation is significant on the clustered index, especially if...
February 19, 2013 at 10:13 am
Bhuvnesh (2/18/2013)
ScottPletcher (2/18/2013)
Cluster the table by the most common WHERE conditions; make the clustered key unique by including the Policy_transactional_ID on...
February 19, 2013 at 10:11 am
David Moutray (2/18/2013)
ScottPletcher (2/18/2013)
In implicit transaction mode,...
February 18, 2013 at 5:24 pm
Viewing 15 posts - 6,556 through 6,570 (of 7,413 total)