Viewing 15 posts - 3,856 through 3,870 (of 6,035 total)
GilaMonster (5/20/2015)
Grant Fritchey (5/20/2015)
SELECT TOP 10 without any kind of ORDER BY or WHERE clause? If so, that's going to result in an index scan.
Shouldn't be too much of...
May 20, 2015 at 12:37 pm
When a table scan occurs, do the pages read equate to the total 20 GB size of the table? If so, then that explains why a table scanning query would...
May 20, 2015 at 11:44 am
meerack11 (5/20/2015)
I am currently looking for job as sql developer company gives sql query to solve so can you help me where I can find real time scenario...
May 20, 2015 at 10:58 am
mdsantos (5/20/2015)
Analysing the "bad" execution plan, I notice that the searches where done with index scan instead of index seek, incresing drastically the...
May 20, 2015 at 9:02 am
Mr Corn Man (5/20/2015)
Yes, the registry change was on the server. I have access to do that, but not to the tnsnames. Go figure.
It's neat that you got openrowset on...
May 20, 2015 at 8:55 am
Mr Corn Man (5/20/2015)
In addition to this query, part of the solution required me to add a registry DWORD value for the OraOLEDB.Oracle provider. That registry value was DisallowAdHocAccess with...
May 20, 2015 at 8:31 am
Routing late night operational alerts is one thing, but from a DevOps perspective, we also have the power to auto-fix certain issues without even raising an alert. For example, if...
May 20, 2015 at 7:52 am
SQLRNNR (5/19/2015)
If you are hiring for a senior position, you create an exam for the position, you require...
May 19, 2015 at 9:58 am
Regardless of method, first the Oracle client, at least the Instant Client, must be installed on the SQL Server box.
For a linked server connection, you'll need a TNSNAME....
May 19, 2015 at 7:48 am
Iwas Bornready (5/19/2015)
In our small environment we have one person that does it all. So he'll be talking to himself about our VMs.
Yes, in small companies the IT department is...
May 19, 2015 at 7:18 am
TrailRunner (5/13/2015)
May 19, 2015 at 7:00 am
Post DDL for the table, including the constraints, defaults, and indexes. Also the insert statement.
May 18, 2015 at 2:32 pm
Iwas Bornready (5/18/2015)
What a great idea. I totally agree. Let me see if I can optimize it even more and then force sql to use my version.
Real DBAs hand code...
May 18, 2015 at 2:26 pm
I've never installed SQL Server in a production environment, but I've installed it at dozens of times on my work PC, laptop, and in development. There are several points in...
May 18, 2015 at 10:34 am
I googled, and it appears that the Default Trace can be used to track several types of changes to login properties... but not a password change, which would seem to...
May 18, 2015 at 9:18 am
Viewing 15 posts - 3,856 through 3,870 (of 6,035 total)