Viewing 15 posts - 391 through 405 (of 476 total)
ramana3327 (9/15/2015)
Step: Moving the production server latest backup from its local drive to Test server local drive
Pedantic point but I expect that needs to be COPYING rather than MOVING as...
September 15, 2015 at 5:08 pm
tDub44 (9/15/2015)
the output depends on the given report type
In the example you provide the WHERE clause is a simple "PKey = @customerID" and is suspect whatever parameter is provided...
September 15, 2015 at 5:01 pm
ScottPletcher (9/15/2015)
Look for a maintenance plan that is rebuilding indexes
Won't an index rebuild CHECKPOINT after each index? - and thus would I be right in thinking that this would represent...
September 15, 2015 at 4:51 pm
johnsonchase7 (9/15/2015)
This actually works for me
Syntax of all the parameters in all the calls is identical (sequence and space padding etc)? No quoting of numbers sometimes, and passing them...
September 15, 2015 at 4:48 pm
_simon_ (9/15/2015)
I save fingerprints in my database and I have to send every fingerprint with a quality larger then some constant to another system
Do you have to send such records...
September 15, 2015 at 4:38 pm
sqlinterset (9/15/2015)
I used the function as cast('1-12-2012' as Date)
That format is "ambiguous" and will depend on your Locale setting (which is both server-dependent and depends on the language...
September 15, 2015 at 4:27 pm
GilaMonster (9/15/2015)
Kristen-173977 (9/15/2015)
john_rowles (9/14/2015)
LatePost = COUNT(CASE WHEN AttendanceReason = 1 THEN 1 END),
PostOut = COUNT(CASE WHEN AttendanceReason = 2 THEN 1...
September 15, 2015 at 3:50 am
Koen Verbeeck (9/15/2015)
Yeah, but less collisions.
Naive question, but isn't the problem any POSSIBILITY of collisions?
September 15, 2015 at 3:48 am
How big is the Data file? If it is smaller than the 220GB Log File I'd go looking for the transaction that is causing the log file growth. ...
September 15, 2015 at 3:43 am
You can use COUNT_BIG(*) but it may take AGES to run ... getting the Row Count from the clustered index / heap might well be a better solution - unless...
September 15, 2015 at 3:38 am
DamianC (9/15/2015)
I'm aware of profilers but, as the sp is running, can't really set this up now
SQL Profiler should be able to show you the next statement to be executed...
September 15, 2015 at 2:35 am
I think the only reason for this is a long running transaction. Its a heck of a transaction though ...
I would put something in place that recorded (to a table)...
September 15, 2015 at 2:31 am
faulknerwilliam2 (9/15/2015)
DATEPART(YEAR, a.Date) = DATPART(YEAR, GetDate())-1
Whatever method you use, I expect you will find that
WHERE a.Date >= @FYStartDate
AND a.Date...
September 15, 2015 at 2:26 am
john_rowles (9/14/2015)
LatePost = COUNT(CASE WHEN AttendanceReason = 1 THEN 1 END),
PostOut = COUNT(CASE WHEN AttendanceReason = 2 THEN 1 END),
LateNoPost =...
September 15, 2015 at 2:19 am
Can you change the Sproc? If it were me I would, temporarily, add some logging to the Sproc.
Even rename the SProc and write a wrapper, with original name, that...
September 15, 2015 at 2:08 am
Viewing 15 posts - 391 through 405 (of 476 total)