Viewing 15 posts - 3,511 through 3,525 (of 7,191 total)
If you don't have any auditing set up then you're not going to be able to find out much. For DDL changes, you can try the default trace.
If you...
June 16, 2014 at 3:41 am
Probably not - it's not something that SQL Server controls. You'd be better off speaking to your AD administrator.
John
June 16, 2014 at 2:50 am
Then you'll need to explain your requirement better, please. Perhaps you could post some sample data and expected results based on that data?
Thanks
John
June 12, 2014 at 9:31 am
If all you're trying to do is return the whole result set in pages of @PageSize rows, just remove the PARTITION BY clause from your ROW_NUMBER function.
John
June 12, 2014 at 8:52 am
No, only the stuff you would have got from cat_transaction.
John
June 12, 2014 at 7:02 am
Dax
No, you can stop just SQL Server Agent. Or you could use a proxy account. Bear in mind that will only work for scheduled backups. If you...
June 12, 2014 at 5:46 am
Dax
A differential backs up every page (or is it extent?) that has been changed since the last full backup. The index rebuild was just an example - if anything...
June 12, 2014 at 5:07 am
The reason I created this trigger is because the data will only be inserted one at a time, so if there are two records being inserted then the trigger will...
June 12, 2014 at 5:00 am
I don't know how they import the data from the front end, this is a new system.
I just know they use a third party application to import it. (This is...
June 12, 2014 at 4:20 am
And if I disable the trigger and do another transaction, then it writes the "lost" transaction and the new transaction to the db.
Are you doing your insert as part of...
June 12, 2014 at 3:43 am
SQL Guy 1 (6/11/2014)
You can run differential backup. For these 4 days, it will be smaller than full.
Not necessarily. If, for example, you've rebuilt all your indexes during...
June 12, 2014 at 3:31 am
crazy_new (6/12/2014)
it doesn't store the transaction in the DB until I disable the trigger.
Do you mean that the insert into cat_transaction doesn't happen? If so, it looks like there's...
June 12, 2014 at 3:29 am
Manoj
You can restore a backup made with SQL Server 2008 R2 on a SQL Server 2012 server. Don't forget to change the compatibility level on the database to that...
June 12, 2014 at 3:15 am
You're partitioning your results by NewTitle. If the size of those partitions is smaller than your page size, then you will get all rows returned.
John
June 12, 2014 at 2:51 am
smtzac (6/11/2014)
Total DB size is 790 GB. doesn't this help? My question is what's the appropriate size for this large db after shrinking the log file.
I'm afraid it doesn't help....
June 11, 2014 at 9:02 am
Viewing 15 posts - 3,511 through 3,525 (of 7,191 total)