Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 61

SQL Server 2014 (major build version 12.0.xxxx). Please also tag sql-server.

5
votes
I Tried You should include what you tried in the question - any detail you can give helps us help you understand. How to merge multi statement into one select statement. You don't say what …
answered May 25 '17 by David Spillett
9
votes
You can't rename the files while they are in use, and don't make them "not in use" by stopping the SQL Server, it won't pick up on the change automatically. The quickest way is as follows: Detach t …
answered Oct 12 '15 by David Spillett
7
votes
Your manager will be concerned about possible regressions and new bugs in the service pack (rare, but it has happened in the past) or one of your applications relying on an undefined behaviour that is …
answered Jun 15 '17 by David Spillett
1
vote
Actually, tCompressedBinary sounds like it might be a true UDT (a user-defined type implemented using CLR) rather than a UDDT (a user-defined data type, which are just aliases for other types created …
answered Oct 13 '17 by David Spillett
0
votes
One possibility: Between 2012 and 2014 some significant changes were made to the cardinality estimation routines. While these changes create massive improvements for some complex queries there are a f …
answered Jul 14 '16 by David Spillett
1
vote
I don't know of an easy way to just extract them and reapply to another target, but you could use the data in sys.extended_properties to generate a script to add the properties to another database usi …
answered Feb 24 '15 by David Spillett
1
vote
The queries are simple selects from single tables. There are a number of details that you need to include that may have an effect here. Are they many small resultsets (a few rows or small rows) o …
answered May 30 '17 by David Spillett
4
votes
But the restore never completes. using SP_WHOISACTIVE the complete_percentage is null ( for like, 10 minutes ). 10 minutes is not nearly enough time to qualify for using the word "never"! Wha …
answered Aug 1 '16 by David Spillett
2
votes
The short answer is no: if a transaction makes changes to the data all those changes have to be written to the log as this is how SQL Server manages atomicity. The more advanced answer is: it depends …
answered Feb 2 '18 by David Spillett
5
votes
The is some information directly from MS that you might find useful: Breaking Changes to Database Engine Features in SQL Server 2016 and Discontinued Database Engine Functionality in SQL Server 2016, …
answered Sep 15 '16 by David Spillett
5
votes
This is not possible: the display settings can not be specified per column. If you set the font to one which definitely supports relevant Unicode code points, you can use these characters instead of …
answered May 19 '16 by David Spillett
0
votes
Will the above changes help my Disk utilization to be at least bit lower than before. Because expanding drive each time is becoming burden for us. Yes, if you currently rebuilding all indexes eve …
answered Jul 21 '17 by David Spillett
2
votes
In this instance replacing td = CAST([PercentUsed]as varchar(30)), with something like: td = '<span style="color:' + CASE WHEN PercentUsed > 95 THEN '#FF0000' ELSE '#40C211' + '">' + CAST([Percent …
answered Jan 4 '18 by David Spillett
4
votes
As Brent points out: real data (if even the smallest part of it is at all sensitive) should not be on dev/test[1] systems at all, even temporarily. If you do depersonalise real data for use in test e …
answered Oct 8 '18 by David Spillett
2
votes
Looks fine to me. Because of the way that SQL Server schedules writes, keeping logs and data on separate volumes doesn't save as save as much performance as many think for many workloads (it does hav …
answered Aug 11 '16 by David Spillett

15 30 50 per page