Viewing 15 posts - 1,051 through 1,065 (of 7,499 total)
double check the file isn't used by an other database than the one you are trying to restore.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 10, 2015 at 1:41 am
haven't seen any remarks about concatenated ( meaningfull ) keys yet.
Recently had to tune a query full of substrings because pos 2 to 4 had a originating status code and...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 10, 2015 at 12:21 am
check out Understanding the concept of SQL Server Failover Cluster[/url]
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2015 at 6:05 am
if this is a migration project, did you consider SQL Server Upgrade Assistant for msaccess ( MS freeware ! ) ?
http://www.microsoft.com/en-us/download/details.aspx?id=42656
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2015 at 6:01 am
FYI you are missing out the COALESCE function, which you can consider a recursive ISNULL.
Personally I prefer Isnull and Coalesce over a Case expression to accomplish the same functionality.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 2, 2015 at 12:02 am
More popular is sticking date time values in nvarchar datatyped columns, of course accepting any client format without storing the culture nor format.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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]...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 21, 2015 at 6:23 am
exquisite set of winners and runner ups !
Congratulations to them all and thank you for your contributions !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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 !
How to obtain the latest service pack...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 19, 2015 at 6:37 am
did other customers disable connection pooling ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 14, 2015 at 12:34 am
Viewing 15 posts - 1,051 through 1,065 (of 7,499 total)