Viewing 15 posts - 1,021 through 1,035 (of 7,467 total)
More popular is sticking date time values in nvarchar datatyped columns, of course accepting any client format without storing the culture nor format.
January 31, 2015 at 1:32 am
another reason why I ( and many of my peers ) don't like maintenance plans.
So I schedule my own backup jobs, including an extra step to copy the bak files...
January 30, 2015 at 1:23 am
Chances are the LinQ query :
SELECT
[GroupBy1].[A1] AS [C1]
FROM ( SELECT
COUNT(1) AS [A1]
FROM [dbo].[tblApplPlan] AS [Extent1]
WHERE [Extent1].[SuperLinkIPPlanID] = @p__linq__0
) AS [GroupBy1]
Is only used...
January 28, 2015 at 7:42 am
I would pick the smallest definition that fits your requirements, but stick with Dr Codd's rules[/url] as tight as possible !
CREATE TABLE [MyFinancialSchema].[FX](
[Uniid] [int] NOT NULL primary key,
[Fx_Id] [int]...
January 27, 2015 at 2:36 am
as much as I dislike sending emails from within a trigger .....
Double check you are executing the mail query in the correct database ?
Check parameter @execute_query_database
January 21, 2015 at 6:23 am
exquisite set of winners and runner ups !
Congratulations to them all and thank you for your contributions !
January 21, 2015 at 2:15 am
Kicking in open doors, but why is this SQL2008R2 instance still on the RTM build ? ( April 21, 2010 )
Current is SP3 !
January 21, 2015 at 2:06 am
spaghettidba (1/19/2015)
Zohaib Anwar (1/19/2015)
I am not sure how can I check this in SQL Server ?? Is there any option / setting in SQL to enable or disable that??
No, it's...
January 19, 2015 at 6:37 am
did other customers disable connection pooling ?
January 19, 2015 at 6:21 am
spaghettidba (1/13/2015)
GilaMonster (1/13/2015)
Erland Sommarskog (1/12/2015)
As I understand it, membership in sysadmin means that all permissions checks are waived.
Correct.
Any login that's a member of the sysadmin fixed server role bypasses ALL...
January 14, 2015 at 12:34 am
Can you check on your NAS that the target folder isn't compressed ?
I've seen sqlserver backup commands having issues with windows compressed folders.
January 14, 2015 at 12:28 am
Roust_m (1/12/2015)
ALZDBA (1/9/2015)
Never, and I mean NEVER , add fk constraints using the NOCHECK option !!!ref: http://www.scarydba.com/2010/11/22/do-foreign-key-constraints-help-performance/ ( read the comments ! )
This is a replicated database with NOT ALL...
January 12, 2015 at 11:49 pm
simple: total db size = data file size + log file size ;
20GB + 8GB = 28GB
January 12, 2015 at 11:45 pm
You can easily get an overview of all completed backup commands and their generated backup sizes, as they are registered in msdb !
declare @DbNameLike sysname
declare @OnlyLastBUset bit
Select ...
January 12, 2015 at 7:56 am
Viewing 15 posts - 1,021 through 1,035 (of 7,467 total)