Viewing 15 posts - 3,271 through 3,285 (of 6,041 total)
Kim Crosser (10/19/2015)
Jeff Moden (10/17/2015)It's no wonder C-Level types think they don't need a DBA.
But doesn't Microsoft sell SQL Server against Oracle by telling everyone they don't need a DBA...
October 19, 2015 at 11:41 am
GoofyGuy (10/19/2015)
Bad management can impact the effectiveness of our technology organizations, and it's silly to accept bad managers. This is something that can be fixed ...
... by the staff grabbing...
October 19, 2015 at 10:07 am
There is a system table called sys.sql_expression_dependencies which contains references between objects, for example when a view or stored procedure references tables. If referenced_database_name is not null, then the referenced...
October 19, 2015 at 9:40 am
BL0B_EATER (10/19/2015)
Eric M Russell (10/19/2015)
GilaMonster (10/19/2015)
Eric M Russell (10/19/2015)
GilaMonster (10/19/2015)
October 19, 2015 at 8:58 am
GilaMonster (10/19/2015)
Eric M Russell (10/19/2015)
GilaMonster (10/19/2015)
October 19, 2015 at 8:02 am
GilaMonster (10/19/2015)
October 19, 2015 at 7:31 am
Renée (6/23/2011)
I'm a SQL newbie who sort of inherited a 2005 db. I've got a query that returns a SUBSTRING of a field value in one column. I need...
October 16, 2015 at 12:52 pm
Run while "SET STATISTICS IO ON", so we know how many actual page reads.
October 16, 2015 at 10:55 am
As for the option of sticking around and "fixing" your current job, unless you're in a position of influence, I find that ideal outcome to be plausible... but unlikely. It's...
October 16, 2015 at 10:25 am
GeorgeCopeland (10/16/2015)
Eric: So things don't get fixed at the current job, it will be any different at the next??? Not really.
So after an initial honeymoon period, even a smart guy...
October 16, 2015 at 8:28 am
What are the advantages of using CLR instead of a stored procedure? For performance reasons, programming that processes data should be as close to the data as possible, preferably all...
October 16, 2015 at 7:39 am
As for the option of sticking around and "fixing" your current job, unless you're in a position of influence, I find that ideal outcome to be plausible... but unlikely....
October 16, 2015 at 7:26 am
Jeff Moden (10/15/2015)
Eric M Russell (10/15/2015)
Create indexes on the NEW tables. Remember to create clustered indexes before non-clustered indexes.
As with a clustered index rebuild, the HEAP will be preserved...
October 16, 2015 at 7:15 am
timwell (10/15/2015)
So my questions: What is Access best at? What are data professionals using it for?
I am using Access 2010. Are later versions more useful?
Should I tell our intern to...
October 16, 2015 at 7:02 am
timwell (10/15/2015)
Eric M Russell (10/15/2015)
I believe Excel is more often used for professional data analysis than MS Access. What functionality is missing from Excel that she finds in MS Access?
I...
October 16, 2015 at 6:50 am
Viewing 15 posts - 3,271 through 3,285 (of 6,041 total)