Viewing 15 posts - 2,461 through 2,475 (of 6,041 total)
dndaughtery (7/20/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2016 at 12:26 pm
There is an existing operator, schedule, notification framework for use by SQL Agent and SQL Alerts, and you may be able to leverage these existing tables. What you're wanting to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2016 at 9:12 am
We've all been in situations where the organization has a legacy application for which there is no designated owner; meaning that the developer who built and supported it left years...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2016 at 7:43 am
Which aspect of this do you need advice on?
Create a table to contain one row for each DBA along with their contact details and what days of week / hours...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2016 at 6:59 am
Steve Jones - SSC Editor (7/19/2016)
Eric M Russell (7/19/2016)
I was listening to a web developer talk about some fundamental changes in a web platform. In this case, an older system...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 19, 2016 at 9:58 am
I was listening to a web developer talk about some fundamental changes in a web platform. In this case, an older system was being replaced completely with a new one,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 19, 2016 at 6:52 am
For one-off or infrequent formatting, there are several web-based options.
http://www.bing.com/search?q=online+t-sql+formatter
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 18, 2016 at 2:57 pm
SQLRNNR (7/18/2016)
Definitely work from remote. It is easier to get more accomplished. There are typically fewer interruptions and fewer water cooler moments.
When working remotely, one will miss out on a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 18, 2016 at 2:46 pm
Hash matched joins between very large tables will also do it. I once had to troubleshoot an ETL process that would run for days until eventually filling a 1 TB...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 18, 2016 at 2:38 pm
Many folks are willing to pay as much as 50% more for locally sourced food, thinking (for example) that milk or vegetables from China may be less wholesome and more...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 18, 2016 at 1:00 pm
Any difference in exeution time would be the result of T-SQL syntax pre-processing; one is probably just a macro of the other. All other things being equal, the actual compiled...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 18, 2016 at 12:16 pm
Even for those DBAs who work 8am - 6pm from the office, we bring our laptops home for on-call support. If we can handle emergencies remotely, then it's not that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 18, 2016 at 11:22 am
BTW, how and why were the additional URL parameters added to my above link?
Is this something new on SQLServerCentral?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 18, 2016 at 11:17 am
I'm not sure if SQL Server Express Edition has the 'Default Trace' turned on by default or even if it supports event auditing in general. A google search gave no...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 18, 2016 at 11:14 am
Also keep in mind that these users may be members of yet another domain (or local admin) group that has a SQL Server login. For example, confirm if 'BUILTIN\Administrators' has...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 15, 2016 at 8:57 am
Viewing 15 posts - 2,461 through 2,475 (of 6,041 total)