Viewing 15 posts - 46 through 60 (of 93 total)
Thanks for a good and interesting article on a topic that rarely gets much attention!
June 9, 2014 at 6:35 am
halifaxdal (6/2/2014)
Ed Pollack (6/2/2014)
halifaxdal (6/2/2014)
Where can I download the database? All I found are for newer version like 2008R2 or DW2008R2Thanks.
The scripts here were tested with Adventureworks2008 as well as...
June 2, 2014 at 9:34 am
halifaxdal (6/2/2014)
Where can I download the database? All I found are for newer version like 2008R2 or DW2008R2Thanks.
The scripts here were tested with Adventureworks2008 as well as AdventureWorks2012---you can use...
June 2, 2014 at 9:04 am
You can use this same syntax for updates, but there are only INSERTED and DELETED tables (there is no UPDATED). For all intensive purposes, an update is a combination...
June 2, 2014 at 6:17 am
Sending it over now --- I've really enjoyed messing with the memory optimized features in SQL Server 2014.
Many of the initial responses by the community were very lackluster, citing the...
May 30, 2014 at 12:27 pm
Steve Jones - SSC Editor (5/6/2014)
bump
I'd be happy to take this on. I began hinting at memory-optimized tables and stored procs in my article on SQL Server 2014 DMVs,...
May 29, 2014 at 11:26 am
Jerry Stretch (5/28/2014)
Not to belabor the obvious, but there's a typo in the initial scripts....middle_namwe ,
Yeah, that was my bad---the scripts are valid and run as expected, but we'll consider...
May 28, 2014 at 8:57 am
There are certainly many ways to accomplish this and end up with the same results---but performance is the key in deciding what to do. LEAD and LAG are very,...
May 27, 2014 at 8:53 am
You're 100% correct---and this behavior appears to be undocumented on MSDN. Attempting to run a query with this analytic function results in:
Msg 10762, Level 15, State 1, Line 4
The...
May 27, 2014 at 6:25 am
balu.arunkumar (5/20/2014)
Hi All,Can i refresh view through linked server? I have full rights to modify the view?
Ex:ABC.MNC_DB.dbo.sp_refreshview 'view_ABC'
Assuming the linked server is...
May 23, 2014 at 7:06 am
john.p.lantz (5/22/2014)
May 23, 2014 at 6:59 am
wbellman (5/22/2014)
Goal: To score a set of companies based on set business rules that vary from platform...
May 22, 2014 at 1:28 pm
wbellman (5/22/2014)
May 22, 2014 at 8:19 am
curious_sqldba (5/21/2014)
Ed Pollack (5/18/2014)
Comments posted to this topic are about the item <A HREF="/articles/Data+Types/109214/">Comparing Different Data Types</A>
Is there any benefit using CAST Vs Convert to explicitly convert the data types...
May 21, 2014 at 10:02 am
No problem---to get all the columns, just create a date string just like you did at the start, but leave out the INT:
DECLARE @Date1 datetime
DECLARE @Date2 datetime
SET @Date2...
May 20, 2014 at 7:08 am
Viewing 15 posts - 46 through 60 (of 93 total)