Viewing 15 posts - 5,806 through 5,820 (of 18,926 total)
IF OBJECT_ID('tempdb..#dbs') > 0
DROP TABLE #dbs
IF OBJECT_ID('tempdb..#Drives') > 0
DROP TABLE #Drives
IF OBJECT_ID('tempdb..#Results') > 0
DROP TABLE...
May 24, 2011 at 9:58 am
Well sp_spaceused will give you a ballpark idea, it should be good enough unless absolute precision is required.
You could always track daily db gowth with the history in msdb and...
May 24, 2011 at 9:57 am
Quite possible, but I was thinking about totally 3rd party apps. I've once read about one and it looked really good (indexes, views, relations) were also included. Can't...
May 24, 2011 at 9:54 am
bpmosullivan (5/24/2011)
P.S. What's dtTimes (Alias / Derived table) ?
Yes, you can't use a derived table unless you name it.
Also from previous test those types of queries perform a little better...
May 24, 2011 at 9:53 am
If you really want to transfer everything I'd look into access based upsizing wizards. I don't have any recommandations, but those will be built by and for people who...
May 24, 2011 at 9:36 am
No the size of the log on the file system should basically never change unless you see a problem down the line and decide to grow it.
The free space in...
May 24, 2011 at 9:02 am
pwalter83 (5/24/2011)
Ninja's_RGR'us (5/24/2011)
Try changing the query then creating a new report from scratch (just to see if the query runs... no need to rebuild the rest)
Actually that is the problem...
May 24, 2011 at 9:00 am
Try changing the query then creating a new report from scratch (just to see if the query runs... no need to rebuild the rest)
May 24, 2011 at 8:53 am
Definitely yes.
I'd also try deleting the parameter and remaking it.
May 24, 2011 at 8:42 am
reindex operations are logged. Figure 1.3 to 1.5X the base data and that's how big the log needs to be (on top have whatever else is going on).
May 24, 2011 at 8:40 am
What error are you getting?
Comparing a date to a date has never been an issue for ss.
May 24, 2011 at 8:29 am
I've used this in the past with access but I guess it could work in VS.
IDAutomation.com Code 39 Free Font
May 24, 2011 at 8:20 am
sqlnaive (5/24/2011)
Unfortunately that brings me to the same point where I started. In a complex stored procedure, what should be the thumb rule for implementing temporary data [records upto 800].
I...
May 24, 2011 at 8:18 am
Then put it back as datetime in the parameter of the report.
If it still fails, dump all the converts in the query (to test) and it should work.
May 24, 2011 at 8:07 am
John Mitchell-245523 (5/24/2011)
Almost... you need an INNER JOIN on the Name column.John
Actually you'd need a full outer because you need all data in both tables. So I preffer to...
May 24, 2011 at 8:01 am
Viewing 15 posts - 5,806 through 5,820 (of 18,926 total)