Viewing 15 posts - 4,096 through 4,110 (of 9,643 total)
Grant Fritchey (10/8/2009)
Arggghhh. This is just frustrating.
Hey, you must have helped. The problem is solved;-)
October 8, 2009 at 8:14 am
This should get you started:
Declare @html varchar(max);
Set @html = '<g:cn> The ComplanyName </g:cn>';
Select
@html,
Stuff(@html, Patindex('%<g:cn>%', @html) + 6, Patindex('%</g:cn>%', @html) - (Patindex('%<g:cn>%', @html)...
October 8, 2009 at 8:14 am
GSquared (10/8/2009)
Since we're pretty much shooting...
October 8, 2009 at 7:56 am
George is right that is a big subject, but basically if you take the defaults you are usually all set. Here's the basics for each one:
Server Status - this...
October 8, 2009 at 7:47 am
GSquared (10/8/2009)
I don't even use...
October 8, 2009 at 7:12 am
Dave Ballantyne (10/8/2009)
Can anyone wave their magic sql wand ?http://www.sqlservercentral.com/Forums/Topic799860-149-1.aspx
EDIT :
Maybe its ItalianOlgi's first day on the job
Abracadabra, alakazam, alashabast server run fast!
October 8, 2009 at 5:15 am
Well, you haven't told us what the performance issue is. It looks like it is not something related to CPU, so that leaves it to memory, disk, network, design,...
October 8, 2009 at 5:13 am
I had pointed to the link on DMV's because the objects you were trying to access were DMV's and in the article it mentioned that a user needs VIEW SERVER...
October 8, 2009 at 5:08 am
Jeff Moden (10/7/2009)
Excellent tip/reminder on the "next day" thing, Jack.
Thanks. I used to be a BETWEEN guy, but about a year ago I had a discussion here on SSC...
October 7, 2009 at 8:45 pm
mbrady5 (10/7/2009)
Thats it....thanks! Is there a way to insert date picker controls in the report?
If you add parameters to the report and select the Date datatype for them then SSRS...
October 7, 2009 at 8:42 pm
I realize I am back in this thread long after the original problem was solved, but I'm wondering what the solution was and also wanted to offer some more information....
October 7, 2009 at 7:45 pm
I think this is what you are looking for:
SELECT
Record_Id,
DateCreated,
LastUpdated,
...
October 7, 2009 at 7:26 pm
I'd store as varbinary with encryption done by the business layer.
October 7, 2009 at 3:00 pm
I'm not sure what your question is? DO you want the Date parameter to be filtered to only allow a certain range of dates to be selected? Like...
October 7, 2009 at 2:52 pm
Normally I don't like to post "I agree posts", but in this case I will. I agree with Silverfox. Clean up ownership issues and then delete the...
October 7, 2009 at 2:44 pm
Viewing 15 posts - 4,096 through 4,110 (of 9,643 total)