Viewing 15 posts - 5,206 through 5,220 (of 49,552 total)
I would strongly recommend you don't. While a query like that is possible, it's an almost guaranteed performance problem, it'll also be hard to maintain and difficult to understand.
Why aren't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2015 at 6:04 am
You won't be able to put an IDENTITY property on the KeyTestDate column, only one column in a table is allowed to be an identity.
Also, if it's a date, shouldn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2015 at 6:03 am
Naina_11 (7/23/2015)
will be making sure that there are only trusted connections.
??? The script you posted uses SQL authentication, not trusted connections. Trusted connections don't send username and password, they...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2015 at 4:34 am
Repeating exactly the same thing again and again isn't giving me more detail!
A backup is of a database, an entire database, not a query. You cannot put a select...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2015 at 4:31 am
You don't want hardcoded passwords unless you want a security nightmare. It's horrible security practice.
How about using trusted connection and ensuring that the SQL Server service account has login rights...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2015 at 4:29 am
You don't.
For SQL authentication, SQL stores the password hashed, the plain text is not available anywhere. If it's windows authentication, then the domain controllers have the hashed password and all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2015 at 4:10 am
Repeating the question doesn't really help with giving more detail. Could you explain the problem in more detail please?
What are you trying to do? What problem are you trying to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2015 at 3:48 am
Could you please explain in a bit more detail what it is you need?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 23, 2015 at 3:10 am
To be in 2nd normal form a table must be in 1st normal form and no non-key attribute may depend on part of the candidate key.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 7:48 am
Brandie Tarvin (7/22/2015)
GilaMonster (7/22/2015)
Are you sure nothing's running index rebuilds on them?
The job we have runs once a week on Sundays, not during the week. So I know that is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 6:03 am
Terminology first. AlwaysOn is a marketing term, not a feature.
The features are:
Always On Availability Groups
Always On Failover Clustering
Always On Availability groups are the feature which replaces mirroring, the multiple servers...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 5:45 am
Are you sure nothing's running index rebuilds on them? Have you tried running an XE session overnight to confirm?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 5:37 am
A lot of copy-paste work.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 5:30 am
Yes, providing you use the correct events and have the required access to the server. But don't ever use profiler (the GUI) against a production server, it can cause nasty...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 4:08 am
Please note: 5 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2015 at 4:04 am
Viewing 15 posts - 5,206 through 5,220 (of 49,552 total)