Viewing 15 posts - 3,856 through 3,870 (of 6,038 total)
Server names that include it's physical location are problematic when the server is relocated to a different data center. Like wise a name like MSSQL2012 is problematic when it's upgraded....
May 21, 2015 at 6:21 am
Gary Varga (5/21/2015)
May 21, 2015 at 6:11 am
Tom_Sacramento (5/20/2015)
Yes, limited columns gives much better performance
It looks like the results are for a handful of tables in MASTER database. When running the script, change context to database containing...
May 20, 2015 at 2:34 pm
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
Viewing 15 posts - 3,856 through 3,870 (of 6,038 total)