Viewing 15 posts - 16 through 30 (of 57 total)
Depending on your resources you might want to look at using snapshots. Create 20 or so databases using backup/restore and then create a snapshot on each one. If the students...
March 23, 2015 at 4:34 am
Indexed views store data in the database.
https://technet.microsoft.com/en-us/library/ms187864(v=sql.105).aspx
March 23, 2015 at 4:28 am
It would be useful if you could post the table schema and script to populate it with your test data. Reading your code the results look to be correct. All...
March 23, 2015 at 4:20 am
SELECT
SUM(CASE WHEN FooName = '' THEN 1 ELSE 0 END) AS [blank],
SUM(CASE WHEN FooName = '' THEN 0 ELSE 1 END) AS [notblank]
FROM...
March 20, 2015 at 1:39 pm
To see how many times a table is touched you could use sys.dm_db_index_usage_stats. This can show how many times the table is updated or referenced in a query. You need...
March 20, 2015 at 1:22 pm
Not sure if this is what ou want but something like this will read the table once and add give totals per month.
SELECT
SUM(CASE WHEN month(salesdate) = 1 THEN...
March 20, 2015 at 8:48 am
If it's a dev environment with not too much traffic I would go with a trace filtering on the statement txt for the table name. This will as give a...
March 19, 2015 at 6:08 am
One part solution could be to give temp access just for the duration of the update. Grant SYSADMIN on request for short period for them to do the updates and...
March 18, 2015 at 12:53 pm
Probably not useful but the standard approach I've always used is to this is to give developers the access they need in a Dev environment and when they can show...
March 16, 2015 at 11:06 am
I'm not a fan of missing index reports unless I have really drilled in deep to the queries touching a table. You need to look at the queries accessing the...
March 16, 2015 at 10:27 am
or...
create stored procedure for maintenance of the two tables and include the necessary check logic in them. Then don't give anyone datawriter. Give them execute on the stored procedures....
March 16, 2015 at 6:06 am
How about creating a readonly snapshot of the database and giving having them run their ownernight queries against the snapshot. That should give them what they need and give you...
March 16, 2015 at 5:55 am
I'm not 100% sure I undertand but if you want each row to have a percentage of the total by department it will interesting as the % in all rows...
March 16, 2015 at 5:44 am
Triggers might help but could be complex. You would need triggers on both tables to manage/control changes to either table.
March 16, 2015 at 5:30 am
Not seen SQL call Powershell but seen lots of powershell scripts calling SQL.
Why are you renaming the files ?
If it's to ensure a file is only processed once you may...
March 16, 2015 at 5:20 am
Viewing 15 posts - 16 through 30 (of 57 total)