Viewing 15 posts - 5,716 through 5,730 (of 22,219 total)
I'd say neither.
Instead, I'd suggest normalizing the scores/marks out to their own table. Then, store them as the correct decimal values. Rounding and prettying can occur on the application/reporting side...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:51 am
For unstructured or semi-structured data within the Microsoft sphere, you're looking at HDInsight[/url], they're version of Hadoop, or DocumentDB[/url]. If you want to stay within the Microsoft stack, and I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:50 am
You can use DBCC FREEPROCCACHE to target a single execution plan. Something like this:
SELECT @PlanHandle = deqs.plan_handle
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE dest.text LIKE 'CREATE PROCEDURE dbo.MergeSalesOrderDetail%'
IF...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:46 am
WayneS (8/11/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:40 am
Full disclosure, I work for Redgate.
There are really two tools on the market that provide everything you need for database build and deployment. The first is Redgate SQL Source Control...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:32 am
The SQL Server Database Tools (SSDT) can do most of the work it sounds like you're doing manually. You just have to use the CREATE PROCEDURE syntax to put the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:26 am
JManuelN (8/12/2015)
Have you tried to attach a SQL Server Profiler so you can see what is doing while you open the restore window? It maybe give you some hint.
Sorry for...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:20 am
Something must be wrong with your SQL Server Management Studio then. I just validated that it does exactly the same thing on my system as it has always done, open...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:18 am
Brandie Tarvin (8/12/2015)
SQLRNNR (8/11/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:14 am
WayneS (8/11/2015)
Any other Threadizens going to the Louisville SQL Saturday next week?
Nope. Omaha this week and then Okie City at the end of the month.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 5:13 am
Lynn Pettis (8/11/2015)
Can't place the movie or show that came from, but love the editing!
Big Trouble in Little China.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 11, 2015 at 12:10 pm
SQLRNNR (8/11/2015)
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
ATTRIBUTE1...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 11, 2015 at 11:48 am
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
VARCHAR(1)...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 11, 2015 at 9:43 am
Ah, you did the second thing I suggested. Cool.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 11, 2015 at 8:49 am
Sure thing, move the WHERE clause to the ON clause and it'll work.
OUTER JOINs are kind of funny in that if you put filtering criteria in the WHERE clause...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 11, 2015 at 8:26 am
Viewing 15 posts - 5,716 through 5,730 (of 22,219 total)