Viewing 15 posts - 18,046 through 18,060 (of 49,552 total)
Without table definitions, just a guess but maybe enough to get you on the right track
Update Bankroll
Set <whatever>
FROM Bankroll inner join (SELECT
Username
FROM
CASINO.BankTransaction
WHERE
DateAndTime >= DateAdd(hh, -24, GETDATE())
AND
(Trantype LIKE 'Win'
OR
Trantype LIKE 'Lose')
GROUP...
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 15, 2012 at 9:41 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs.
DBCC TRACEON(1222,-1)
Or, since you're on SQL 2008, 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
June 15, 2012 at 9:28 am
Extended Events.
Jonathan Kehayias has an example somewhere on his blog, google should find 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 15, 2012 at 9:01 am
Shouldn't depend on anything other than whether there are LOB columns in the table or not.
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 15, 2012 at 8:47 am
If you're on Enterprise Edition and there are no LOB columns in the table, then you should be able to create the clustered index online with the ONLINE option of...
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 15, 2012 at 8:13 am
Often enough that should corruption be found, restoring from a clean set of backups is always an option.
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 15, 2012 at 7:46 am
Just the create table and create index (or alter table ... add constraint) statements. In an attachment if they're huge. Otherwise just inline (using the [ code ] blocks
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 15, 2012 at 7:44 am
Identities aren't supposed to maintain a sequence without gaps. Why does it matter?
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 15, 2012 at 7:17 am
On the log maintenance, maybe take a read through this: Managing Transaction Logs[/url]
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 15, 2012 at 7:15 am
Table definitions and index definitions please?
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 15, 2012 at 7:09 am
No. A full backup when restored is always the same as the database it was backed up from, including file sizes, and there is no way to override that. You...
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 15, 2012 at 7:09 am
Please post table definitions, index definitions and execution plan as a .sqlplan file, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
A picture of the exec plan is not that useful, most of the info 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 15, 2012 at 6:42 am
No.
A full backup doesn't include the entire log, but when you restore it, the files will be the same size as in the source DB, so if the log file...
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 15, 2012 at 5:49 am
Well, as I said without a lot more technical details I can't recommend an HA/DR that will fit.
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 15, 2012 at 5:47 am
The main consideration here is that a database with filestream can't be mirrored (and a mirrored database cannot have filestream added)
For 40kb average for the blob, filestream's not the best....
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 15, 2012 at 5:25 am
Viewing 15 posts - 18,046 through 18,060 (of 49,552 total)