You searched for the word(s):
Showing page 1 of 186 (1,851 total posts)
< 1 second(s)
Last week, Microsoft released an out-of-band hotfix to resolve an issue surrounding excessive RESOURCE_SEMAPHORE_QUERY_COMPILE waits. If you are experiencing this issue, or if you are diligent about applying the most recent hotfixes, you should apply this fix.
You will need to enable trace flag 6498 in order to benefit from the fix; installing ...
@brykneval That works well enough (I still don't like having to scan across to find where all the column names start), but only if all of your column names fall under a certain count. When you start having expressions, and expressions that can span multiple lines, you will soon see it is not so easy to have visual alignment anywhere other than at ...
Microsoft has released Cumulative Update #5 for SQL Server 2014.
KB Article: KB #3011055
56 fixes total (47 fixes listed publicly at time of publication).
Build number is 12.0.2456
Relevant for @@VERSION 12.0.2000 through 12.0.2455
Wow, what compelling arguments. You might lose data integrity and need to fall back on a "known" identity value. Not having an identity column is incompetent and lazy. *sigh*
@jon I'm not quite sure how the code in the post is failing you, but I can see at least two ways your new code could go wrong:
(1) INFORMATION_SCHEMA only holds the first 4,000 characters
(2) PRINT has an 8K limit
Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon.
SQL Server 2012 Service Pack 1 Cumulative Update #13
13 fixes (10 public)
Relevant for Service Pack 1 only ...
Vikas, your clients should be patched to >= version of the highest server you have to manage. Always.
That said, I am not the guy to ask about SSDT. I don't think the story on that side of the house is a very good one...
Microsoft has released Cumulative Update #4 for SQL Server 2014.
KB Article: KB #2999197
66 fixes total (54 fixes listed publicly at time of publication), including several fixes for Management Studio.
Build number is 12.0.2430
Relevant for @@VERSION 12.0.2000 through 12.0.2429
Microsoft has released the final Service Pack (SP4) for SQL Server 2008.
Build # 10.00.6000
KB Article: KB #2979596 (Download)
6 public fixes, including important security fixes from MS14-044
Relevant for builds < 10.00.6000
NOT for SQL Server 2008 R2 (10.50.xxxx)
Once more, this is the last service pack for SQL ...
You're right Chris, I've added that info (I was a little cautious mentioning it since the KB doesn't currently list it).