Viewing 15 posts - 5,206 through 5,220 (of 49,571 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...
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...
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...
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...
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...
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...
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...
July 23, 2015 at 3:48 am
Could you please explain in a bit more detail what it is you need?
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.
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...
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...
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?
July 22, 2015 at 5:37 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...
July 22, 2015 at 4:08 am
Viewing 15 posts - 5,206 through 5,220 (of 49,571 total)