Viewing 15 posts - 1,306 through 1,320 (of 7,168 total)
Sergiy (4/9/2013)
quackhandle1975 (4/9/2013)
I should have been clearer, I was not saying avoid triggers.
Yes, this one looks very different. 🙂
They say - consider environment. Look at the name of the article...
April 9, 2013 at 4:01 pm
I agree, it ought to work unless they are repositioning SQL Server away from Enterprise use and moving more towards Home use 😀
April 9, 2013 at 11:22 am
I cannot think of a reason why that would be a problem for the database engines but you may run into issues with some of the shared services depending on...
April 9, 2013 at 10:58 am
Phil Parkin (4/9/2013)
opc.three (4/8/2013)
April 9, 2013 at 10:08 am
I am happily running SQL 2012 Dev Edition on Windows 8 Pro and oddly enough Windows 8 Enterprise is not listed as a supported OS here.
April 9, 2013 at 8:40 am
I am thinking initially it could be blocking but it truly could be any number of things. When they run it on the laptop I assume it's just the one...
April 9, 2013 at 8:32 am
Signing stored procedures using a certificate is useful when you want to require permissions on the stored procedure but you do not want to explicitly grant a user those rights.
April 9, 2013 at 8:19 am
USE [master]
GO
EXEC sys.sp_addlinkedserver
@server = N'Production',
@srvproduct = N'',
@provider = N'SQLNCLI',
@datasrc = N'127.0.0.1,1713'; -- fix...
April 9, 2013 at 12:15 am
How are your C# or VB.net skills? I am thinking pre-processing the file might be one way. You could use a Script Task to read the file in reverse order...
April 8, 2013 at 11:59 pm
Sergiy (4/8/2013)
opc.three (4/8/2013)
April 8, 2013 at 10:58 pm
Sergiy (4/8/2013)
quackhandle1975 (4/8/2013)
Odd reply, Sergiy. My comment was aimed at beginners and programmers who find themselves coding t-sql.
I reread your comment 5 times more - it does not say...
April 8, 2013 at 10:39 pm
peacesells (4/8/2013)
AND SO.[type]='X_P'
AND vu.[Status]=1
AND 1= CASE WHEN @CreateDateDatTime > vu.LastRunDate
...
April 8, 2013 at 10:36 pm
Duplicate post. Direct replies here: http://www.sqlservercentral.com/Forums/Topic1440114-391-1.aspx
April 8, 2013 at 10:27 pm
But how index can be visualize.is it same as that of index on books.
Pretty much. Non-filtered indexes will have an entry for every row in the table, sorted per the...
April 8, 2013 at 10:25 pm
Yep, I remember that thread well...it's not the leaf level of the index that becomes fragmented, it's the mid-level pages because the clustering key is stored there. You were wrong...
April 8, 2013 at 10:13 pm
Viewing 15 posts - 1,306 through 1,320 (of 7,168 total)