Viewing 15 posts - 1,711 through 1,725 (of 6,035 total)
Don't know if you are still in the same position (us retired members don't...
February 14, 2017 at 6:02 am
For bulk importing data, I'd use SSIS over a stored procedure. If a stored procedure call is one smaller step in a broader ETL process, then it should be called...
February 13, 2017 at 2:22 pm
Many careers develop partly by accident and/or opportunity. But myself, like many others got here...
February 13, 2017 at 10:03 am
February 13, 2017 at 9:51 am
February 13, 2017 at 7:42 am
Database performance tuning is one of the four pillars of a competent well rounded DBA. You're handicapped in that regard if you don't know T-SQL. Even if you're not the...
February 13, 2017 at 7:09 am
... The second item that I worry about is the care someone takes when performing a task. In this case, any of us might have been tired at 9pm....
February 13, 2017 at 6:43 am
If you don't have a working knowledge of T-SQL, then you're going to be handicapped when it comes to database administration or business intelligence.
February 10, 2017 at 11:30 am
You can also leverage Google to search SQL Server Central by keyword like so:
site:sqlservercentral.com +"Kindest Regards,Rod" +"clustered index"
February 10, 2017 at 10:35 am
February 10, 2017 at 9:56 am
Some companies may even...
February 10, 2017 at 8:36 am
This article lists 13 jobs that were once staples but today no longer exist due to automation.
http://ijr.com/2014/09/173651-13-jobs-used-important-longer-exist/
February 10, 2017 at 8:13 am
... there was a prediction that IT departments wouldn't exist in 5 years, meaning in mid 2018. That's a year and a half away. Is that a possibility? ...
February 10, 2017 at 8:02 am
Also, the session settings XACT_ABORT or ARITHABORT can influence behavior of stored procedure to an error.
February 10, 2017 at 6:26 am
A T-SQL step within a job will by default run under the security context of the SQLAgent service account or alternately under context of a proxy account that you have...
February 10, 2017 at 6:14 am
Viewing 15 posts - 1,711 through 1,725 (of 6,035 total)