Viewing 15 posts - 13,261 through 13,275 (of 49,552 total)
Read up on SQLAudit
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
May 4, 2013 at 3:32 am
What does the procedure proce_Name do?
btw, I strongly recommend against any architecture or design that has pieces of queries being passed around as parameters, it gets hugely complex, there are...
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
May 4, 2013 at 3:30 am
Possible, yes. Whether it's a good idea or not is another matter.
What happens if that's a long-running data import. Job automatically kills it after 2 hours, job rolls back for...
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
May 3, 2013 at 1:54 pm
I'll call BS on that. Changing the max memory setting is not going to affect SQL writes.
Could be that you have bad plans getting into cache (maybe problematic plan caching),...
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
May 3, 2013 at 1:52 pm
OnlyOneRJ (5/3/2013)
I think due to the Drive full & continues DML transaction on that DB.. the File must hacve corrupted..
Full log will send the DB read only, not corrupt 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
May 3, 2013 at 10:50 am
Can't figure out from your description what the exact situation is and what the specific problem is.
What happened (exactly, not vaguely)?
What is the current situation (specifics)?
What is the exact problem...
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
May 3, 2013 at 10:16 am
Lynn Pettis (5/3/2013)
What version (edition) of SQL Server ar you currently using?
Express. Was stated earlier.
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
May 3, 2013 at 9:37 am
IT researcher (5/3/2013)
Whether any other tweaks available which can help me to remove replication related data from it?
It's not that there's replicated data, there's replication markers left in 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
May 3, 2013 at 9:34 am
IT researcher (5/3/2013)
So 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
May 3, 2013 at 5:08 am
They should be near-identical in time (and bear in mind that SQL's timers aren't accurate down to the ms level, that's stats time and perfmon). While the second does do...
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
May 3, 2013 at 3:38 am
Not an open transaction (and detaching and attaching would never solve that, detaching and attaching a database won't change anything within the database)
Either the database has had replication in 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
May 3, 2013 at 3:24 am
Lowell (5/2/2013)
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
May 2, 2013 at 6:40 am
Varchar(N) for N 1..8000 can be stored 'in-page', that means with the rest of the row. Over that, it has to be stored in a list of LOB pages (each...
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
May 2, 2013 at 6:37 am
Encryption doesn't stop you from seeing the data, just that you'll see binary values (0xA45B2DF999212...) rather than something you can understand
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
May 2, 2013 at 4:27 am
http://msdn.microsoft.com/en-us/library/aa197950%28v=sql.80%29.aspx
Script out your jobs first, all logins, backup history, DTS packages, linked servers, server-level permissions. Since you have no backups, there's no other solution here, that corruption's not repairable.
Afterwards check...
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
May 2, 2013 at 4:26 am
Viewing 15 posts - 13,261 through 13,275 (of 49,552 total)