Viewing 15 posts - 3,841 through 3,855 (of 11,678 total)
Is there a specific reason SQL Server has to have the same bitness as MS Office?
You should be able to install multiple instances of Express.
I don't see how you would...
January 23, 2014 at 6:38 am
My general opinion on the SO moderators is that they are a bunch of twats.
It's probably just a few rotten apples with a big ego, but they ruin it for...
January 23, 2014 at 6:27 am
Always funny to see what you categorize as a "short" article Jeff 😀
It's a great one though and I'm sure I'll refer to it soon in the future when I...
January 23, 2014 at 6:16 am
In some aspects an OLTP database and a data warehouse are much alike: indexes and statistics need to be maintained, queries must be fast et cetera.
There are important differences though:...
January 23, 2014 at 5:21 am
Grant Fritchey (1/23/2014)
rodjkidd (1/23/2014)
Koen Verbeeck (1/23/2014)
rodjkidd (1/23/2014)
...and told him to search the internet for videos of Grant.WHAT HAVE YOU DONE?!?
He He - I know - can we turn the internet...
January 23, 2014 at 4:47 am
rodjkidd (1/23/2014)
...and told him to search the internet for videos of Grant.
WHAT HAVE YOU DONE?!?
January 23, 2014 at 3:54 am
arrjay (1/23/2014)
You should take transaction log backups more often, once you have preformed a transaction log backup you can then execute a shink command on your .ldf file.
Why...
January 23, 2014 at 3:44 am
You could add a row number (using a script component) to both flows and then use the MERGE JOIN component.
January 23, 2014 at 3:11 am
THE-FHA (1/23/2014)
Backup with compression for trn is only available on SQL2012 and this is a SQL 2008 R2 log shipping solution.
SQL 2008R2 supports backup compression:
January 23, 2014 at 3:09 am
I guess this is an Oracle query?
In SQL Server you need to use the ROW_NUMBER function and sort in the OVER clause.
In an outer query you can select the row...
January 23, 2014 at 2:06 am
THE-FHA (1/23/2014)
Hi,Do you mean i should restrict log growth to 1MB for instance?
Cause currently the database is set to unrestriced growth of 5MB.
Noooooooooo.
You have two settings: the incremental steps at...
January 23, 2014 at 1:52 am
THE-FHA (1/23/2014)
Can someone help me on how to reduce the log file growth so that it is kept at minimum.
Minimize log file growth? Do less stuff on your database. (you...
January 23, 2014 at 1:25 am
By giving (GRANT/DENY or adding them to roles) the appropriate permissions to people?
For example, you can add people to the DDL_ADMIN role if you want them to execute DDL.
If you...
January 23, 2014 at 12:35 am
Probablly the way how those browsers interprete the HTML/CSS code.
January 22, 2014 at 11:53 pm
You can either use try/catch or check with a CASE statement if @datediff1 is 0. If it is, don't do the division and return 0, if it isn't do the...
January 22, 2014 at 11:52 pm
Viewing 15 posts - 3,841 through 3,855 (of 11,678 total)