Posts
Sort by recent activity
Setup Clone
I get the following error: Failed to open http://LUIS-HP:14145/
Windows domainusername: LUIS-HPLuis
What I'm missing?
Thanks.
Graphics - Log Size tempdb partially incorrect
I have 4 tempdb files. In Analysis, temdb size, log size show total correctly.
But if I choose one point in particularly, wrong value.
Example:
Log1 : 1GB
Log2 : 1GB
Log3 :1GB
log4 : 1GB
Total : 4G...
Block Process Start Times.
I have the following:
Details
Block occurred at: 3 Jun 2013 10:33 AM
Processes
Blocked process: XXXXXXX
Process ID: 99
Database: XXXX
Host: SERGIO
User: SERGIO
Start time: 3 Jun 2013 8:41 AM
Blocki...
Maintenance Window
This is a suggestion.
Actually we can set maintenance window i.e from 11pm, 5 hours.
May be is more useful working time:
From Monday to Friday, 6am to 10pm and nothing on weekends or Monday to Frid...
SQL Process in alert mail
I'm free lance DBA so I don't work all day long with one client.
I was wandering if there is any way to get, via mail, wich query is locking or high duration, etc.
No problem when I'm in the client...
Hosted Storage
Is there a way to override Hosted Storage backup?
Blackout Periods and some wait time
I would like to know if there is any way to set:
1) Blackout Periods.
2) Some waits time like: Profiler, backups, etc.
Thanks,
SQL Jobs
Any new about SQL Jobs documentation?
Error logs the DBA way issue
Failed to execute SQL.
Error converting from nvarchar to datetime (spanish to english translate)
Exact
I have one database with a lot of tables with column name "transac".
Also I have the following table:
CREATE TABLE [dbo].[FX_ScriptTransactions](
[IdScript] [varchar](50) NOT NULL,
[Error] [int] NU...