Viewing 15 posts - 1,426 through 1,440 (of 5,685 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,...
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...
June 25, 2012 at 3:01 pm
Steve Jones - SSC Editor (6/25/2012)
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/
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...
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...
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...
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...
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...
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. ...
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. ...
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...
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.
June 21, 2012 at 12:54 pm
Duplicated topic. Please direct all conversation here:
http://www.sqlservercentral.com/Forums/Topic1319548-8-1.aspx
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...
June 21, 2012 at 12:46 pm
Viewing 15 posts - 1,426 through 1,440 (of 5,685 total)