Viewing 15 posts - 1,996 through 2,010 (of 2,458 total)
ELLEN-610393 (1/21/2014)
I will read up on the FILESTREAM / and storing BLOBS outside of the database.
Will also test using varbinary(max) .
The images should not...
January 22, 2014 at 3:06 pm
Prassad Dabbada V R (1/21/2014)
you cannot pass parameters to ViewFor parameterized views please check below link
http://msdn.microsoft.com/en-us/library/c11kd98s(v=vs.80).aspx
You can also think of an inline Table Valued Function (iTVF) as a parameterized view....
January 22, 2014 at 2:47 pm
Hopefully you understand what Evil Craig was saying. To put it another way: you cannot click on the XML returned from a SQL query in SSMS and see a header...
January 22, 2014 at 2:35 pm
Nice work on the article.
I was putting together a way to populate dimdate using a tally table but see that Louis beat me to it. Thought I would include...
January 21, 2014 at 1:34 pm
Grant Fritchey (1/13/2014)
Alan.B (1/13/2014)
I took a quick look at this and there does appear to be a lot parameter sniffing but there's a lot of other problems too.
I'm confused....
January 15, 2014 at 8:40 am
I will ignore your comment about suggesting that always using NOLOCK is a good idea when integrity of the results is not important.:w00t:
To be clear (and to avoid being the...
January 13, 2014 at 1:00 pm
First is that the query plan from SSMS (the faster version)? Is it possible to provide both?
I took a quick look at this and there does appear to be...
January 13, 2014 at 11:09 am
kbhanu15 (1/9/2014)
Hi All,can any one clarify the difference between NOLOCK and WITH(NOLOCK) in sql server 2008 ?
which one is the best practice to use ?
Thanks
Bhanu
I think everyone did a good...
January 13, 2014 at 10:19 am
I know this is a few days old but I thought it would be good to expand on this a little:
The W3C defines two technologies for "Transforming XML": SQLXML/XQuery...
January 8, 2014 at 1:41 pm
Unless I am mistaken it appears that you cannot add CDATA to the XML data type. This is a known Microsoft bug which they doesn't look like it's getting fixed....
January 8, 2014 at 12:29 pm
Do you have any DDL/Sample data for [alpsMaster].[dbo].[uExtractMonitor]? ... and some sample data for what will go into files? If you can provide that I am sure we can help...
January 8, 2014 at 12:15 pm
Great Article Solomon. Very easy read and informative. I have been looking forward to a SSC Stairway on CLRs for a long time and look forward to the rest of...
January 8, 2014 at 8:38 am
I just read this article. Great work Wayne.
December 27, 2013 at 9:55 am
Minnu (12/17/2013)
Hi Team,Please help in below query, it should return TRUE.
DECLARE @req_1 varchar(50)
DECLARE @req_2 varchar(50)
set @req_1='AAM'
set @req_2='VVE'
if (@req_1 !='AAM' OR @req_2 !='VVE')
print 'TRUE'
ELSE
print 'FALSE'
It's worth noting that you...
December 18, 2013 at 2:56 pm
kennethrbell (12/12/2013)
Before that:
I opened the “Apologies…” email last week from SQLServerCentral.com (very catchy...
December 13, 2013 at 10:30 am
Viewing 15 posts - 1,996 through 2,010 (of 2,458 total)