Viewing 15 posts - 7,276 through 7,290 (of 13,469 total)
SQL 2005? is this 64 bit or 32 bit?
June 28, 2011 at 2:48 pm
there is no default order by.
without an ORDER BY , ther eis no guarantee the data is returned in any order.
sometimes, by coincidence, the data is returned in the...
June 28, 2011 at 2:44 pm
it kind of sounds like some dynamic sql and using sp_sendmail would do the trick, just as Welsh Corgi suggested; i'd like to see a little more detail, like a...
June 28, 2011 at 12:38 pm
here's my quick take.
1. Rebuild Indexes - good.
2. Update Statistics - only for those columns NOT participating in an index, since the Rebuild of the Index takes care of the...
June 28, 2011 at 9:35 am
i cannot think of another way to do it easily; row_number makes the join simpler, but you could join two copies of the tables together based on the name ...
June 28, 2011 at 9:00 am
no way to do types, views , procs or functions automatically...you have to edit them and make their definitions find-and-replace ready for editing.
the originals typically may reference items in the...
June 28, 2011 at 8:55 am
the list is a list of all ODBC drivers installed and registered on the server .
the ace driver gets installed when you install this:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d
it might also be installed if you...
June 28, 2011 at 8:12 am
looks like you are missing another function: dbo.weeknumber
June 28, 2011 at 7:53 am
Krasavita (6/28/2011)
Can some one help me how to create provider.Thank you
can you explain what you mean? do you mean adding ODBC providers to your SQL instance? like adding Oracle, DB2...
June 28, 2011 at 7:52 am
Bliar thanks for posting what you found back; I updated my post, and PM'd Gianluca to make him aware of what you found;
I'm sure that this will help someone else...
June 28, 2011 at 7:35 am
something like this? i leave it to you to decide teh datediff period of time....i chose hours, you can change to days
/*--Results
rw ...
June 28, 2011 at 7:19 am
June 28, 2011 at 7:04 am
another way to avoid the parameter sniffing is to use local variables as well: here's another example to consider.
CREATE PROCEDURE AVOIDSNIFFING(@Param1 int=0,@Param2 datetime = NULL)
AS
DECLARE @localParam1 int,
...
June 28, 2011 at 6:39 am
opc.three is right; I've done something similar with console apps and xp_cmdshell, as well as CLR.
no matter how you do it, it's outside of SQL...so it doesnt belong inside a...
June 28, 2011 at 6:35 am
Viewing 15 posts - 7,276 through 7,290 (of 13,469 total)