Viewing 15 posts - 9,586 through 9,600 (of 39,804 total)
jasona.work (6/18/2015)
Steve Jones - SSC Editor (6/18/2015)
Left the kids on their own as my wife and I are in the UK....
June 18, 2015 at 6:23 am
You can't do
select sum( select myfield from mytable)
from mytable
If you want to work with two sets of data from the table and calculate different aggregates, then you need...
June 18, 2015 at 2:42 am
paul.millar (11/26/2013)
I've found config manager opens a connection - kill it, restart sql service, try again
That's interesting. Didn't know that.
June 18, 2015 at 2:29 am
You can't easily do this from T-SQL. T-SQL/SSMS executes inside of the server, not in the file system. There is no BULK EXPORT, mostly because the commands you run are...
June 18, 2015 at 2:27 am
Teach him to just drag the columns from Object Explorer (or get SQL Prompt). Easy fixes for the dev that aren't a big deal.
June 18, 2015 at 2:21 am
Those are good memories, but I'm glad we're past that.
Left the kids on their own as my wife and I are in the UK. At 14, 16, 23, they're managing...
June 18, 2015 at 2:12 am
ramana3327 (6/17/2015)
Is there any way to get notify from sql server when the dump files are getting created?
Do you mean backups? These are noted in the log, there are trace/events...
June 18, 2015 at 2:04 am
As Gail mentioned, mirroring can help. Backups are needed, but so is DBCC. Corruption can flow into backups.
June 18, 2015 at 2:04 am
Specialized backups certainly have issues. They're really exports of data, and the importer is responsible for ensuring integrity, but having copies of lookup tables, or other specific (and limited data),...
June 16, 2015 at 8:11 am
http://www.sqlservercentral.com/articles/Stairway+Series/72461/
The likely cause if your call to the service might be looking for a password. That would get the .exe to freeze.
June 15, 2015 at 10:18 am
Frozen IO doesn't mean consistent. The backup needs to respect transactions.
June 15, 2015 at 9:57 am
The job runs under the context of the Agent service or the proxy. Be sure that account has rights. You might log in as that account and then try to...
June 15, 2015 at 8:55 am
The only way to check a backup is to restore it.
I have never seen a SQL Server backup fail to restore, unless the file was corrupt. It's a solid process....
June 15, 2015 at 8:27 am
I have had a few people I know use mirroring to minimize the downtime. You can do this as well, but be aware that you need to account for the...
June 15, 2015 at 7:48 am
Jeff Moden (6/15/2015)
June 15, 2015 at 7:16 am
Viewing 15 posts - 9,586 through 9,600 (of 39,804 total)