Viewing 15 posts - 18,196 through 18,210 (of 26,489 total)
Not much advice we can give you here as you haven't given us enough information to really help you out.
If you could provide details about the query that exploded the...
November 30, 2009 at 10:36 am
How about something more like this:
select
product_id as Product_ID,
round(cast(sum(case when purchase_id in (4,5) then 1 else 0 end) as float)/
...
November 30, 2009 at 10:34 am
Roy Ernest (11/30/2009)
I hope everyone had a great Thanks giving weekend... :_)
We had our moments, but, overall it was good! Friends went a got Kassondra for a couple days...
November 30, 2009 at 10:27 am
Dude76 (11/30/2009)
I will personaly prefer to do something like cast(cast(getdate() as int) as datetime) to obtain de date of the day at midnight rather using datediff+dateadd functions.
There has been several...
November 30, 2009 at 6:28 am
I use a SQL account with admin access when working from home. I can't start and stop the SQL Server services using this account. If I need to,...
November 27, 2009 at 2:56 pm
Well, I can't defend this one. I have to agree, what good is it to create the job if you can't run it?
November 27, 2009 at 9:07 am
The more you understand waht a DBA does the better. Not so you can argue with him or her, but so that you understand why they do the things...
November 26, 2009 at 7:54 pm
For general information regarding BACKUP and RESTORE I'd start by reading BOL (Books Online, the SQL Server Help System). Your question is really quite open and I'm not really...
November 26, 2009 at 7:48 pm
Thanks Jeff. I fixed the link. 😉
November 26, 2009 at 1:21 am
And if you look around this forum, you will also find that for 99.9% of the time that you think you need a cursor, guess what, you don't.
A majority of...
November 26, 2009 at 1:16 am
I can probably tell you what she would say, the same thing as the rest of us. When setting the autogrowth it is best to set it in MB...
November 26, 2009 at 1:10 am
And, based on the sample data provided, what should our expected results be so we know if our code is correct.
November 25, 2009 at 7:37 pm
Looking at this:
We have a page that searches for Field Orders. Normally, this search take about 5 seconds. On a bad day it takes about 20 seconds. Now it is...
November 25, 2009 at 7:15 pm
Curious. A few things if I may ask, can you provide details regarding your server configuration (memory, processors, x64 or x32 (I'm assuming x64), OS and version, SQL Server...
November 25, 2009 at 7:10 pm
You may want to check both the Share and NTFS permissions for the account on the server the remote file is located.
November 25, 2009 at 4:20 pm
Viewing 15 posts - 18,196 through 18,210 (of 26,489 total)