Viewing 15 posts - 8,401 through 8,415 (of 26,490 total)
Erin Ramsay (3/19/2013)
Why are you shrinking the log file? If your backup method is Full then the logfile will truncate on backup.
Full and Differential backups do not truncate (mark VLFs...
March 19, 2013 at 2:06 pm
TheGreenShepherd (3/19/2013)
Does it matter if that UDF doesn't touch the table dealing with the Key Lookup?
Maybe not, but good chance it could be rewritten as an inline table valued function...
March 19, 2013 at 1:57 pm
Second request, please post the actual execution plan of the query. Save it as a .SQLPLAN file and post it as an attachment to a post on this thread.
March 19, 2013 at 11:50 am
First request please post the code for this function: dbo.GetBenefitName.
March 19, 2013 at 11:47 am
Eugene Elutin (3/19/2013)
B/A 3/19/2013= 7/ 2 = 3.5 not 0.285714286!
Any way thank's to Lowell for data setup:
declare @MySampleData table (Date...
March 19, 2013 at 11:42 am
Not sure what your problem is there. Looks to me like what you need to do is run some tests to determine 1) You get the results you expect,...
March 19, 2013 at 11:11 am
Jeff Moden (3/18/2013)
Evil Kraig F (3/18/2013)
Alright, let's start with the basics. You said you've read up on it...
March 18, 2013 at 9:11 pm
Sergiy (3/18/2013)
mister.magoo (3/18/2013)
I realise this is a bit off-topic for the original question,
I believe the whole thread by now is off-topic for the original question.
but just in case...
March 18, 2013 at 9:02 pm
Sean Lange (3/18/2013)
Sergiy (3/18/2013)
Sean Lange (3/18/2013)
March 18, 2013 at 3:23 pm
Sergiy (3/18/2013)
Sean Lange (3/18/2013)
March 18, 2013 at 3:01 pm
opc.three (3/18/2013)
ChrisM@Work (3/18/2013)
opc.three (3/15/2013)
PS Forgot to mention the function is undocumented so take that into consideration.It's a cough scalar function too.
Meh. We're talking about SQL Agent data so IMHO it's...
March 18, 2013 at 2:57 pm
What happens if you take this out of the call to ROW_NUMBER(): PARTITION BY BatchID. Seem unnecessary since you are calling it with a specific BatchID, unless you also...
March 18, 2013 at 1:43 pm
Eugene Elutin (3/18/2013)
Grant Fritchey (3/18/2013)
opc.three (3/18/2013)
Eugene Elutin (3/18/2013)
If you enable READ COMMITTED SNAPSHOT in the database, it becomes the default isolation level.
For clarity READ_COMMITTED_SNAPSHOT is just a mode of the...
March 18, 2013 at 10:11 am
F. van 't Hoff (11/29/2011)
March 18, 2013 at 9:54 am
No, you are changing the precision of the values and could lose data as you are going from 6 decimals places to 4 decimal places.
March 18, 2013 at 8:15 am
Viewing 15 posts - 8,401 through 8,415 (of 26,490 total)