Viewing 15 posts - 166 through 180 (of 1,162 total)
Jason-299789 (6/17/2013)
You could also do a SELECT * FROM on the NOT EXISTS clause as I belive SQL Server is optimised for the SELECT * in this case.
Don't think...
June 17, 2013 at 10:15 am
Steve Jones - SSC Editor (6/17/2013)
This week is the first SQL in the City of 2013. Anyone coming?
It slipped my attention that it was in London this week and it...
June 17, 2013 at 9:11 am
200 freetext fields and just a PK in addition?
That sounds a pretty unusual requirement, what's it for?
June 17, 2013 at 6:15 am
IT researcher (6/17/2013)
PhysicalDisk value is suppose to be average of LogicalDisk values right? Why this variation caused?
No, I don't think that's the case. It's the % of time that...
June 17, 2013 at 6:06 am
It'll be DiskKeeper:
http://www.sqlskills.com/blogs/paul/diskeeper-10-intelliwrite-corruption-bug/
Would I need to tell them to disable diskkeeper for the duration of dbcc check?
I would advise either upgrading to the latest version, or keep it off...
June 17, 2013 at 4:01 am
Not SQL Server Encryption, 3rd party encryption on the O/S (e.g. TrueCrypt etc.). Or a new install/upgrade of a defrag tool like DiskKeeper. This is likely something at the OS/Storage...
June 17, 2013 at 3:12 am
Doubt that would be the problem.
Do you have any 3rd party I/O drivers, like a defrag tool or software-level encryption?
June 17, 2013 at 2:57 am
Which version of SQL Server? There's a documented bug with DBCC DBREINDEX in 2005:
Note that the command is deprecated anyway and you should use the ALTER INDEX syntax instead.
June 14, 2013 at 6:16 am
Other things to check:
1) Is it a foreign key column in another table?
2) Is the delete getting blocked
June 14, 2013 at 6:12 am
AFAIK, it works like everything else in synchronous mode, e.g. the transaction won't commit until the data has reached the secondary, this could obviously lead to some slow down with...
June 14, 2013 at 3:47 am
Basically to re-iterate what Craig said, you'll need two data flows within the package and conditional execution.
No need for a script task though. Just create a variable in the...
June 14, 2013 at 3:20 am
You can write your own queries, using the DMVs, which is a good learning exercise, but I'd recommend using the brilliant sp_whoisactive.
June 13, 2013 at 8:00 am
Mark-101232 (6/13/2013)
Maybe this?
DENSE_RANK() OVER (ORDER BY IDIS_ACTV_ID,ACTV_HOME_PROPERTY_ID) AS BUILDINGID,
Adding anything else in the order by will screw the DENSE_RANK if they aren't all the same. This should do...
June 13, 2013 at 7:49 am
'2013-06' isn't a date, in string form, or otherwise. It's a year and a month. If you want to convert it to a date, you'll have to add the extra...
June 13, 2013 at 6:11 am
Probably parameter sniffing of some kind and the FULLSCAN is invalidating the poorly performing plan and forcing a recompile (invalidating the existing plan without updating statistics may well have performed...
June 13, 2013 at 2:25 am
Viewing 15 posts - 166 through 180 (of 1,162 total)