Viewing 15 posts - 2,521 through 2,535 (of 2,905 total)
Parse error at line: 1, column: 28:...
June 8, 2017 at 4:08 pm
how to get lowest value fom the code column from the query.
By looking at the...
June 8, 2017 at 2:25 pm
Possibly not the most efficient code, but how about:CREATE TABLE #CODE
(
ID int ,
MOD0 varchar (20),
MOD1 varchar (20),
MOD2 varchar (20),
MOD3 varchar (20),
June 8, 2017 at 2:20 pm
Do you have an antivirus installed on the system?
I know our antivirus sometimes catches the files when we go to delete them and ends up locking it while it...
June 8, 2017 at 1:39 pm
As a weird thought, are all of your differential restores succeeding?
We do not do differential backups, but we do nightly fulls plus hourly t-logs. I have seen strange things...
June 8, 2017 at 10:24 am
BTW-Thanks, that query worked fine.
Since you are an expert on this stuff, let...
June 7, 2017 at 3:38 pm
As a thought, could this be a client processing issue not a server side processing issue?
What I have seen with some of our 3rd party solutions is that the...
June 7, 2017 at 3:31 pm
recommended is 64k due to that being the size of an extent.
An extent is 1 chunck of data that SQL requests. Having your block size and extent size...
June 7, 2017 at 2:19 pm
I believe what you are looking for is the view catalog.object_parameters.
But that will give you the parameters for each DTSX, not for each project. If you want it for...
June 7, 2017 at 2:04 pm
June 7, 2017 at 9:05 am
June 7, 2017 at 8:16 am
June 6, 2017 at 9:36 am
Just send them the memory requirements for SQL Server.
From the MS website:
All other editions: At least 4 GB and should be increased as database size increases to...
June 6, 2017 at 8:37 am
That was an easy one. I am a little confused why 1% of the people picked bigint though? Thinking that has to be a rounding error.... right?
June 6, 2017 at 8:19 am
My job title is DBA, but I do both DBA work and developer work (both database and software).
It really depends on what the company is looking for. I've read...
June 6, 2017 at 8:13 am
Viewing 15 posts - 2,521 through 2,535 (of 2,905 total)