Viewing 15 posts - 3,856 through 3,870 (of 6,041 total)
Executive managment has requested that available MB disk storage (zero padded to 10 digits) be appended to the end of all server names. You know... as a convenience for the...
May 21, 2015 at 8:17 am
dmbaker (5/21/2015)
Eric M Russell (5/21/2015)
Why is including location in server name important for some?
Because when I'm querying a London server from Seattle, I like to know that I can step...
May 21, 2015 at 7:28 am
Why is including location in server name important for some?
May 21, 2015 at 7:16 am
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
Viewing 15 posts - 3,856 through 3,870 (of 6,041 total)