Viewing 15 posts - 4,876 through 4,890 (of 18,926 total)
Happens all the time. I should stop answering so fast. :w00t:
July 14, 2011 at 10:06 am
Not needed anymore.
Lutz finally understood the quoting system.
:hehe:
July 14, 2011 at 9:57 am
ChrisM@Work (7/14/2011)
Ninja's_RGR'us (7/14/2011)
ChrisM@Work (7/14/2011)
You can use a variable in TOP in 2k8, not sure about 2k5:DECLARE @RowsToReturn INT
SET @RowsToReturn = 50
SELECT TOP (@RowsToReturn) * FROM ...
I'm on 2K5 and I...
July 14, 2011 at 9:57 am
ChrisM@Work (7/14/2011)
You can use a variable in TOP in 2k8, not sure about 2k5:DECLARE @RowsToReturn INT
SET @RowsToReturn = 50
SELECT TOP (@RowsToReturn) * FROM ...
I'm on 2K5 and I tested on...
July 14, 2011 at 9:49 am
P.S. Make sure you can't somehow only call this function only once. It's going to get expansive really fast even with cross apply.
July 14, 2011 at 9:41 am
DECLARE @Today DATETIME
SET @Today = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))
DECLARE @AddBusDays INT
SET @AddBusDays = 9
SELECT MAX(dt) AS Nth_next_business_day FROM (
SELECT TOP (@AddBusDays) * FROM dbo.Calendar C WHERE C.dt > @Today...
July 14, 2011 at 9:40 am
You need to figure it out... they won't stop by themselves.
July 14, 2011 at 9:07 am
July 14, 2011 at 6:36 am
My guess is that they should be exactly the same in this case where the search is anywhere in the string. Don't have time to put up a test...
July 14, 2011 at 6:35 am
SQLRO (7/14/2011)
A table created by sa login was...
July 14, 2011 at 6:25 am
muthukkumaran Kaliyamoorthy (7/14/2011)
sqlnaive (7/14/2011)
Friends, we are getting "there is insufficient system memory to run this query" error while working. My machine uses 9.00.4285.00, SP3, Enterprise Edition.
Need more info.
How much total...
July 14, 2011 at 6:24 am
Zeev Kazhdan (7/14/2011)
Same as above, but might be a bit faster:select a.*
from a
join b
on CHARINDEX(a.field_1, b.field_2) >0
Why??? Same logic different function.
Got some tested code to...
July 14, 2011 at 6:23 am
anuraj2k (7/14/2011)
What I understood from your reply is 1000 connections to sql server from a single sql server login (even 1000 connections from application to sql serve...
July 14, 2011 at 6:22 am
Basic idea is that this is to stop all changes that can cause the server to hang (because they would take tones of ressources).
It's not a bad idea to keep...
July 14, 2011 at 6:20 am
Sql server log or bids / ssms?
The message can't really be more clear than that. Add more ram or use less ressources in your query.
July 14, 2011 at 6:19 am
Viewing 15 posts - 4,876 through 4,890 (of 18,926 total)