Viewing 15 posts - 1,426 through 1,440 (of 5,678 total)
bitbucket-25253 (6/25/2012)
Any one know if those spreading Colorado wild fires are threatening Steve's home or the horses? Any one hear from Steve on twitter or whatever?http://news.yahoo.com/colorado-fire-near-pikes-peak-forces-11-000-014551591.html
He's been on twitter,...
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, 2012 at 5:03 pm
Doing audit trails or using Service Broker? Audit trails are relatively easy. Service Broker is a minefield if you've never worked with it before.
I recommend you start with...
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, 2012 at 3:01 pm
Steve Jones - SSC Editor (6/25/2012)
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, 2012 at 12:36 pm
Easiest way is with a FOR XML trick.
Check out this article:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
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 21, 2012 at 4:14 pm
If these fields are all the exact same length than what's posted above by Lynn will work. I'm afraid I don't necessarily agree with Lynn about 01 vs. 010...
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 21, 2012 at 3:26 pm
GilaMonster (6/21/2012)
You don't recreate the partition scheme or function...
The two things you'd do to add a new partition are to mark the next filegroup then add a new partition value...
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 21, 2012 at 3:18 pm
yunis.marrero (6/21/2012)
I'm new to the forum and also still learning about SQL.
so, i'm working on creating a Database warehouse and receiving multiple file from different sources. The...
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 21, 2012 at 1:28 pm
yb751 (6/21/2012)
What would be the best stategy for creating a new partition on the main table in such a way that I would not...
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 21, 2012 at 1:22 pm
Bill, as he mentioned he wants to use only the numeric portions, not just exclude anything with a dash.
Generically, you're going to end up using a LEFT() function to grab...
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 21, 2012 at 1:18 pm
SQLRNNR (6/21/2012)
I know. That's why the space was left intentionally blank:-D:-D
Protip: Do not attempt to match wits on the thread after two days of intensive all day meetings. ...
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 21, 2012 at 1:14 pm
jshurak (6/21/2012)
The login looks ok, except this database is unchecked. Checking it does nothing as it is instantly reverted upon closing out the GUI....
Any thoughts?
Just a basics check. ...
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 21, 2012 at 1:13 pm
Right, because quoting yourself and bolding your own statements is really going to answer my questions.
Let's try this again; since we haven't seen your schema nor your stored procedure, the...
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 21, 2012 at 12:57 pm
SQLRNNR (6/21/2012)
Brandie Tarvin (6/21/2012)
OMG.ROTFLOL
I love it.
I don't get it. What was in your quote? I see nothing.
Heh, I see it fine. It's my current sig, Jason.
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 21, 2012 at 12:54 pm
Duplicated topic. Please direct all conversation here:
http://www.sqlservercentral.com/Forums/Topic1319548-8-1.aspx
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 21, 2012 at 12:54 pm
MERGE seems to be a theme lately. For ease, check out this thread:
http://www.sqlservercentral.com/Forums/FindPost1316908.aspx
If you have further questions after that about it, please, feel free to keep posting either in...
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 21, 2012 at 12:46 pm
Viewing 15 posts - 1,426 through 1,440 (of 5,678 total)