Viewing 13 posts - 16 through 28 (of 28 total)
II) All IDs columns are... numeric(18,0)
III) Almost all tables got a COMPANY_ID and a...
April 19, 2017 at 7:37 am
February 16, 2017 at 7:21 am
What does this return?
[font="Courier New"]select name, physical_name from sys.database_files where type_desc = 'FILESTREAM';[/font]
January 11, 2017 at 7:40 am
No, but you can
[font="Courier New"]ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = ON)[/font]
so that column-level changes are tracked, and then use [font="Courier New"]CHANGE_TRACKING_IS_COLUMN_IN_MASK[/font] to identify the columns that were changed.
January 11, 2017 at 7:31 am
Exclude the appropriate files per the Microsoft guidelines, & you should be able to run anti-virus software with minimal performance impacts: How to choose antivirus software to run on computers...
November 3, 2016 at 7:54 am
You said not on RDS. So does that mean you're using an EC2 SQL Server Windows instance?
Native SQL Server Backups don't support S3 -- Native backups have...
October 5, 2016 at 9:00 am
I have to second Jeff's questioning of the use of varchar(max)...
Before indexing it would seem valuable, even crucial, to review the data types.
Can DNS entries or Protocol really...
October 5, 2016 at 7:29 am
They are working 45 hours a week
So they're part-time? 😉
October 5, 2016 at 6:53 am
Forgot to mention e) as a best practice, avoid such date formats in code. 'yyyy-MM-dd' and 'yyyyMMdd' are both ANSI-standard (I believe) and should.be interpreted correctly and unambigously by the...
June 9, 2016 at 8:49 am
Yes, the services all run, and I can run sqlcmd. SQL Server Profiler works. But SQL Server Management Studio is unusable.
March 1, 2009 at 4:58 pm
They are using different ports.
February 23, 2009 at 8:10 pm
Ditto.
Anybody have any answers?
SQL Server 2008 installed side-by-side with SQL Server 2005 Developer Edition.
Noticed it after I installed SP1 and the Silverlight 2 Tools
February 22, 2009 at 8:52 pm
Viewing 13 posts - 16 through 28 (of 28 total)