Viewing 15 posts - 706 through 720 (of 7,631 total)
Service Broker to SQL CLR should work OK too. IIRC, reading from a Web Service is one of the first SQL CLR examples in BOL.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 8:46 pm
Somebody has that Excel file open, or has a dangling lock left on it. My guess would be that its you, since you just changed it. So do...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 8:26 pm
You should be aware that although no City in the U.S. that I know of crosses state lines, some may effectively cross county lines, and many cover more than one...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 8:09 pm
Unfortunately, it can take a while for AD changes to propagate to whatever SQL Server is using to Cache it. It have seen it take up to 24 hours...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 8:02 pm
That depends. Do you want to be able to read the SQL CLR assemblies that the developers are going to want to put on your databases or not? ...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 7:57 pm
Please read this Article: Example of Safely Using Dynamic SQL with User Selected Table Name. Just do what it says, except for your column name instead of the table...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 7:51 pm
I agree with Welsh, I couldn't understand what you were asking us for.
Also, the design of your tables looks very non-relational. "No repeating columns" is a very important relational...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 7:45 pm
Your crawl is probably still running, how long it takes depends on how much data it has to cover. I am no expert on FTS, but I have had...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 7:41 pm
Since you're on SQL 2008, pass the IDs in as a TVP (table-valued parameter) and receive the results back as a datatable. SQL CAT's test have generally shown this...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 7:32 pm
Has this table been TRUNCATEd?
IIRC, this is a known bugfeature of truncating a table with an Identity column.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 12:52 pm
It may sound crazy, but I think that your function would work better as an in-line TVF.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 12:38 pm
GilaMonster (3/8/2010)
CirquedeSQLeil (3/8/2010)
And it is also a reason why I would love to get into a consulting gig.
There are downsides. I've just spent 3 weeks writing documentation and reports (til...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 12:23 pm
Great Hrubaru, I'm glad it worked out! 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 2:27 am
Paul White (3/7/2010)
Running a full-text search with a variable as a parameter can be problematic. You might have noticed that the full-text engine can provide...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 8, 2010 at 2:08 am
Well I think I've got it. You can call the following procedure from your code, it should do what you need:
CREATE PROCEDURE FTSearchProducts(@strPhrase as VARCHAR(MAX), @AreaID as Int =...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2010 at 10:17 pm
Viewing 15 posts - 706 through 720 (of 7,631 total)