Viewing 15 posts - 2,731 through 2,745 (of 6,041 total)
If you have a new project in development and plan to leverage some of the newer features like Clustered ColumnStore or InMemory tables, then definately go for v2016.
However, if...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 11:40 am
Rod at work (4/5/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 11:31 am
.. I was advised by the Sixbit dev's that I should move the listing pictures out of the dB and into their own folder on the C: drive of the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 11:15 am
So here comes the question: if you were do decide on SQL practices that were always wrong, what would you include?
The following practices are almost always wrong.
1. A table without...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 8:56 am
When listening to new coworkers talk about why they left their previous job, a common theme is escaping stress and overtime. They probably won't mention it as a motivation during...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 7:00 am
I know what you're wanting to do is simple, but SSMS output grid just isn't designed for it. Instead, consider building a simple SSRS dashboard style report for this.
https://www.mssqltips.com/sqlservertip/1361/building-a-dashboard-in-sql-server-reporting-services/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 6:42 am
What problem are you trying to solve? The execution plan for a stored procedure will be cycled out the plan cache when it hasn't been called for a long period...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 4, 2016 at 2:06 pm
FTP is a logical choice for providing scheduled data extracts to an external client, especially if they can potentially be more than a handful of MB. If what they need...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 4, 2016 at 1:42 pm
Actually there is a fork of MySQL 5.5 that supports ANSI-2011, PL/SQL, and T-SQL 2012. In addition to that, it has distributed scale out capability.
https://sourceforge.net/projects/mysql_hydra
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 4, 2016 at 1:21 pm
It's all about disparities in the economic of supply and demand. You want to position yourself so that it's works for you rather than against you. Students who graduate from...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 4, 2016 at 10:01 am
First, learn what a table is, and what relational data is. I also suggest the Stairway tutorials found here as a study guide. In your case, specifically the following as...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 1, 2016 at 2:51 pm
Frankie-464050 (4/1/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 1, 2016 at 1:07 pm
Seggerman-675349 (4/1/2016)
At my work site occasionally the nightly process that refreshes a SQL database from the main (SAP) tables doesn't run until well into the business day....
First, if...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 1, 2016 at 8:51 am
I can see the potential value for an interactive "3D" view of a database's schema, storage allocation, topology, etc. displayed on existing flat screens. Maybe a SSRS or PowerView report...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 1, 2016 at 8:15 am
You are performing a equijoin between Students and a filtered aggregation of Students that contains only repeated combination of name and dob.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 31, 2016 at 2:52 pm
Viewing 15 posts - 2,731 through 2,745 (of 6,041 total)