Viewing 15 posts - 2,881 through 2,895 (of 5,685 total)
george sibbald (6/27/2011)
June 27, 2011 at 3:13 pm
That's cute, the detailed Express license is AWOL from here:
http://www.microsoftvolumelicensing.com/default.aspx
It's not offered here:
http://www.microsoft.com/sqlserver/2008/en/us/express.aspx
or here (basically same link as offered above):
http://www.microsoft.com/sqlserver/en/us/editions/express.aspx
Or here...
http://www.microsoft.com/sqlserver/2008/en/us/licensing.aspx
Okay, that's getting rediculous. Anyone installed R2 Express lately...
June 27, 2011 at 3:10 pm
repicurus (6/27/2011)
The 4 GB database size limit applies only to data files and not to log files. However, there are no limits to the number of databases that...
June 27, 2011 at 2:32 pm
george sibbald (6/27/2011)
June 27, 2011 at 1:57 pm
mtillman-921105 (6/27/2011)
Is The Thread dying at the hands of Twitter?I suspect that it is. R.I.P. The Thread... 🙁
Oh lord no. The thread will never die...
June 27, 2011 at 1:20 pm
June 27, 2011 at 1:18 pm
Be aware:
repicurus (6/27/2011)
1) Archive data from some of the larger tables, placing them into "archive" databases.You will have to alter any SPROCS, VIEWS, UDF's, etc., used in reporting, where appropriate.
This...
June 27, 2011 at 1:14 pm
Eric M Russell (6/27/2011)
June 27, 2011 at 1:11 pm
aarunkumarreddy (6/26/2011)
Craig Farrell (6/26/2011)
Check out BoL. It's not a hard limit for columns, but a size one. There's no...
June 26, 2011 at 11:40 pm
In SQL Server? That sounds like an Excel question.
Check out BoL. It's not a hard limit for columns, but a size one. There's no row limit other...
June 26, 2011 at 8:22 pm
Jeff Moden (6/26/2011)
June 26, 2011 at 4:57 pm
Eric M Russell (6/25/2011)
Craig Farrell (6/24/2011)
...
Just to confirm, you're familiar with the fact that a CTE is nothing more then a subquery, and has no optimization value? It's merely...
June 25, 2011 at 12:18 pm
hollynor256 (6/24/2011)
I'm a little bit confused I hope you can give me link for basic tutorial.
Sure my little marketing annoyance: http://www.HowNotToBeAShmuck.com
June 24, 2011 at 6:53 pm
skynet_si (6/24/2011)
You're right (it's from mysql)I tried your version but get :
Msg 174, Level 15, State 1, Line 3
The datediff function requires 3 argument(s).
Yeah, he forgot the dd component.
Use:
DATEDIFF(...
June 24, 2011 at 5:21 pm
Eric M Russell (6/24/2011)
Where I've mostly...
June 24, 2011 at 4:16 pm
Viewing 15 posts - 2,881 through 2,895 (of 5,685 total)