Viewing 15 posts - 1 through 15 (of 60 total)
Hey good article Roy !
November 24, 2014 at 8:51 pm
Thumbs up from Curaçao
September 21, 2011 at 5:01 pm
hehe yes my mistake,
I didn't mean to say that it should never happen, just that from my own past experiences I haven't seen a good use for it, but...
July 8, 2011 at 6:53 pm
WITH RECOMPILE has been a new friend of mine for few months only now,
we have a few SSRS reports running against our data warehouse and some of them have...
July 7, 2011 at 5:27 pm
ah sorry, I didn't notice your own correction when looking over the thread
December 13, 2010 at 8:17 am
SELECT [Month] = DATENAME(mm, DATEADD(mm, MONTH(SomeDateTime), 0)), Amount = SUM(SomeAmount)
WHERE SomeDateTime >=...
December 10, 2010 at 10:49 am
Looks like the problem was with my trace definition. I was tracing more then what is required by DTA. Now I split my trace into one dedicated for DTA and...
September 3, 2010 at 1:26 pm
this pop up offers you 2 choices, to look online for info on the bug... .which leads nowhere, or to 'close the program'. If you click on that the popup...
September 3, 2010 at 12:06 pm
November 27, 2008 at 8:20 pm
i don't know which problem you are running into when trying to set the DB in single user mode... but usually this would work
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK...
September 18, 2008 at 8:37 am
try catch was introduced with 2k5, he needs his script to work with 2000 as well
otherwise i would agree... try catch is so much cleaner...
September 17, 2008 at 4:40 pm
if you want the ability to commit or rollback depending if an error occured or not you can do something like this:
update Report_T set Cost_AM = 720.00, Total_Cost_RPS_AM =...
September 17, 2008 at 2:23 pm
you can convert the timestamp to binary and then convert the binary to varchar
however my code below involves an undocumented function... not sure if there is a better...
September 17, 2008 at 11:00 am
if this last one doesn't work it would help if you could post a script to create these tables and populate them with few sample entries
September 16, 2008 at 1:25 pm
would that work?
select c.CompID, t.ResID, t.TaskID, t.Date, t.Hours
from dbo.Companies c
inner join dbo.ResourcesEmploymentHistory h on h.CompID = c.CompID
inner join dbo.TrackingHours t on t.ResID = h.ResID...
September 16, 2008 at 1:24 pm