Viewing 15 posts - 2,881 through 2,895 (of 5,678 total)
george sibbald (6/27/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 27, 2011 at 2:32 pm
george sibbald (6/27/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 27, 2011 at 1:20 pm
As Promised: http://www.sqlservercentral.com/Forums/Topic1132391-391-1.aspx?Update=1
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 27, 2011 at 1:14 pm
Eric M Russell (6/27/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 26, 2011 at 8:22 pm
Jeff Moden (6/26/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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(...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 24, 2011 at 5:21 pm
Eric M Russell (6/24/2011)
Where I've mostly...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 24, 2011 at 4:16 pm
Viewing 15 posts - 2,881 through 2,895 (of 5,678 total)