Viewing 15 posts - 16 through 30 (of 147 total)
Do you care what the actual values of the timestamp field are? I can't imagine a case where you would, except where that's your method of generating a row...
December 23, 2009 at 5:56 pm
You can do this using an ALTER TABLE command and specifying a different filegroup for the BLOB data. ALTER TABLE can also be used to move data between filegroups...
December 23, 2009 at 5:34 pm
When you stop the SQL Server service the service account will be logged off the domain. When you try to start the SQL Server service again, whether on the...
November 30, 2009 at 6:15 pm
The account under which the SQL Server service is running on a cluster must be a domain (Windows) account and that account needs SysAdmin rights within SQL Server.
The account under...
November 26, 2009 at 2:45 pm
I'd be seriously looking at consolidating those databases. You could have a single database with a separate schema for each user, which would make your life hugely simpler, plus...
November 18, 2009 at 6:02 pm
SQL Server does not know about non-clustered resources when it is running on a cluster, because it can only see the resources allocated to the virtual server. To be...
November 18, 2009 at 5:55 pm
We had similar problems, although ours was exacerbated because we were using "with standby" at the other end so we had a read-only copy of the database. We ended...
November 18, 2009 at 5:45 pm
Without knowing the objects involved it's impossible to give anything more than generic advice.
As tempdb is used for explicit temporary tables and table variables, eliminate these if possible.
The other major...
October 22, 2009 at 7:07 pm
SQL Server never uses the last 8-10MB on a drive.
It sounds like the easiest way to address your issue is going to be to create a second tempdb data file...
October 22, 2009 at 6:15 pm
tempdb would have been flushed after the command fell over, so the temporary objects that had been created in the background by SQL Server no longer exist. It therefore...
October 22, 2009 at 5:47 pm
You need to use the charindex function together with the left function, as per:
select
left(Vcr1,
(case
when charindex('-', Vcr1) > 3 or charindex('-', Vcr1) = 0 then 3
else charindex('-', Vcr1) - 1
end))
from Test1
October 22, 2009 at 5:39 pm
If you've got the skills in-house to do such a review and those resources can be freed up enough to do the job properly then you don't need to bring...
October 18, 2009 at 7:17 pm
From the results of your query it looks like there's no data in that table. To confirm that, do a select from it.
If there really is no data you...
October 15, 2009 at 3:58 pm
Wherever you've got "grouped filters", ie. filters that need to be applied togather rather than individually, you need to put parentheses around them. Therefore the additional filter you want...
October 6, 2009 at 5:24 pm
G'day Dan,
"Zero-out" is one of those jargon terms that I probably should avoid in the future in such replies. I know what I mean, but that doesn't mean everyone...
October 6, 2009 at 3:30 pm
Viewing 15 posts - 16 through 30 (of 147 total)