6,661 reputation
11147
bio website meltondba.wordpress.com
location Montgomery, AL
age 35
visits member for 3 years, 10 months
seen 10 hours ago

soaking up everything I can about SQL Server and PowerShell.

Twitter

Google+

LinkedIn


1d
comment Where's my missing Sql Server Express 2005 Database space? Size and space available dont add up to 4G?
You might run DBCC UPDATEUSAGE (DB) as SSMS will sometimes get out of sync for those numbers.`
2d
answered Run a PowerShell script on a different server - from inside a SQL Server job
Nov
19
comment Need some questions to show some trends
If you can't come up with your own questions about that dataset pick another one. There are datasets out there on almost everything with weather to baseball.
Nov
17
comment SQL Server 2012: stored procedures permissions
Connect is not a permission for procedures, only the database. Are you referring to execute permissions?
Nov
16
reviewed Close Sync local and master database in Oracle 11g
Nov
16
reviewed Close SQL Delete duplicate rows based on column
Nov
16
reviewed Close Question about logging architecture
Nov
16
reviewed Close Choose a Data Synchronization Technology SQL Server to SQL Server
Nov
16
reviewed Close How to load multiple values in cell from Excel to SQL Server many to many table
Nov
16
reviewed Reject suggested edit on With SSD's and in memory tables, does a snowflake schema become preferred over a star?
Nov
16
revised What is wrong with this INSERT Statement
format, repeated lines
Nov
15
comment Combining log shipping and regular log file backups
You would simply utilize the log backups from your log shipping process in order to restore to a point in time.
Nov
15
answered Combining log shipping and regular log file backups
Nov
15
comment Combining log shipping and regular log file backups
+1 just because I had to lookup what bespoke was...
Nov
12
reviewed Approve suggested edit on Are there any special characters that are never allowed in SQL?
Nov
12
comment Trigger firing when it shouldn't
Just looking at your query this might show what is partially wrong. You need to join the inserted and deleted within your trigger to properly pull valid data. Once you do that I think it should work.
Nov
11
comment SQL Server 2012 Very Slow to Consume Memory
How did you measure memory consumption on the old server, and on new server? Is exact same workload occurring?
Nov
11
revised SQL Server 2012 Very Slow to Consume Memory
tags and bit of formatting
Nov
10
comment Powershell and SQL Script Execution in selected schemas
Just a side note, the OP is on SQL Server 2005 according to tags. Might want to note your solution would require SQLPS be installed.
Nov
7
comment Copy database wizard-generated job blows up log file; alternative?
Simultaneous log backups will help clear inactive log as the inserts or other transactions complete and are finished with that portion of the log. It may still grow a bit but generally helps it from growing rapidly.