Viewing 15 posts - 1 through 15 (of 156 total)
I use SSMS more. I would happily use SSDT more if it wasn't so flaky and crash prone!
June 17, 2019 at 8:34 am
Thanks for your detailed and informative article. Just a FYI: if the files don't have headers then the trivial solution is to run
COPY File1.CSV +...
January 23, 2017 at 12:09 am
When you wrote 'I don't want this to be political' my first thought was 'don't blame the business or management' but that's not what you meant.... so I will blame...
January 15, 2017 at 10:29 pm
In SSMS 2016 there is a script option in the UI if you do properties on the environment... but it doesn't do anything! It seems to be there fore decoration
December 15, 2016 at 10:50 pm
Enforcing data integrity is an important function. Encouraging lazy developers is not. The only time I've ever needed to turn warnings off was to stop NULL aggregate warning bubbling up...
August 23, 2016 at 1:15 am
Thanks for your detailed explanation. I would just caution that a republish of a report can break all of the parameter bindings in a scheduled report. Perhaps it's been improved...
June 29, 2016 at 9:21 pm
Great information - this kind of practical advice is much more valuable than your standard regurgitated walkthroughs. A bit off topic but long overdue for enhancement is the SQL Agent....
March 29, 2016 at 3:59 am
So we discovered that a SQL Server restart (not agent) fixes the issue. Then it happens again. I used process explorer to check the DTExec process and there was a...
May 19, 2015 at 4:46 pm
Thanks for your suggestion but no amount of stopping and restarting jobs helps. Every single job that starts DTExec will hang and repeatedly hang until some kind of magic combination...
April 26, 2015 at 7:18 am
I have a similar problem explained in more detail here:
Intermittently, SQL Agent jobs hang. There's no database activity, no logging. The DTEXEC process has 0 or a couple...
April 23, 2015 at 8:17 am
Did you try all of the suggestions in the prior two pages?
April 20, 2015 at 6:13 pm
I have this exact issue. It appears that the job starts but never starts the package and never finishes.
A restart of the SQL Agent usually fixes it but not this...
January 12, 2015 at 1:09 am
I can't believe I haven't found this earlier. Despite all the comments of 'you should use store procedures' etc., in the real world, a tool that can show me SSRS...
November 17, 2014 at 6:50 pm
Thanks for an interesting article.
From a more theoretical approach, constraints are the things enforcing business logic, not indexes.
As you have observed, indexes are for performance. Unique vs non-unique...
June 26, 2014 at 3:34 am
We are a SQL Server\Visual Studio\TFS shop and I am searching for a DB source control guide using these tools. I'm curious as to why TFS is excluded from your...
April 23, 2014 at 10:52 pm