Viewing 15 posts - 5,626 through 5,640 (of 49,552 total)
Time to schedule a meeting with management and IT security people (and/or HR).
btw, zip passwords are trivial to crack, a quick google search should turn up a pile of tools...
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
June 10, 2015 at 2:22 pm
Or you could just
EXEC adasdb.master.sys.sp_executesql N'RESTORE DATABASE ETLNewTest FROM DISK = ''g:\MSSQL11.MSSQLSERVER\MSSQL\ETL_663.bak''';
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
June 10, 2015 at 9:25 am
Remote query timeout affects queries which this SQL Server instance (the one with the setting) executes against other database engines, via ether OPENQUERY or 4-part naming.
It has no effect on...
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
June 10, 2015 at 8:48 am
Please don't cross post.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1693166-147-1.aspx
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
June 10, 2015 at 5:49 am
Add something into the catch block to send mail, or after the rollback add detail to a logging table.
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
June 10, 2015 at 5:24 am
Zohaib Anwar (6/10/2015)
if we dont put no lock then we get lots of deadlocks in production environment.
You prefer to add a hint that causes incorrect results rather than address the...
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
June 10, 2015 at 5:23 am
Are you sure the case statements are the problem?
And why the nolocks? I'd have thought that the people getting data from a transactions table would like their data correct 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
June 10, 2015 at 4:36 am
Computed column's the only way, but that'll be useless if the queries don't use the computed column. Also, don't assume that the DB is be case sensitive, check whether it...
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
June 10, 2015 at 4:20 am
You can't. Indexes are created on columns, not expressions.
You can, if you need to do this, create a computed column and index that. However that will only be useful if...
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
June 10, 2015 at 3:24 am
shaulbel (6/9/2015)
I think that this is the first step to be done when facing the "Recovery pending" issue.
The first step has to be to identify why the databases are in...
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
June 10, 2015 at 1:34 am
Yes, it matters, but not because it's contageous (it's not)
It matters because after a week or two or a month or ... you may not have the backups 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
June 10, 2015 at 1:33 am
GilaMonster (6/9/2015)
ericpap (6/9/2015)
Joie Andrew (6/9/2015)
Another question, you say that you only have two logs available. If you look at the C:\Archivos de...
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
June 9, 2015 at 1:39 pm
You may get benefits from indexes, you may not. It depends on what kind of join SQL uses. Test and see. Even if you do, they probably won't be large...
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
June 9, 2015 at 1:29 pm
ericpap (6/9/2015)
Joie Andrew (6/9/2015)
Another question, you say that you only have two logs available. If you look at the C:\Archivos de programa\Microsoft...
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
June 9, 2015 at 1:25 pm
Grant Fritchey (6/9/2015)
So tempted to whip out "DO YOU KNOW WHO I AM?"
Need a hand somewhere?
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
June 9, 2015 at 1:19 pm
Viewing 15 posts - 5,626 through 5,640 (of 49,552 total)