Viewing 15 posts - 1,351 through 1,365 (of 7,498 total)
vinu512 (6/14/2012)
I am really sorry to have posted in the wrong Section.
Johan, your solution of CDC...
June 15, 2012 at 12:08 am
- it's all in your db log, but it may take some effort to get it out ... or a vendor tool.
- Is this a one time operation or is...
June 14, 2012 at 7:10 am
Did you try using it with level indication ?
;
with cte ( EventID, EventType, EventName, ParentEventType, ParentEventName )
...
June 11, 2012 at 1:42 am
Nice article, Robert. 😎
Nice enhancement of the GUI. I didn't pay much attention to it, because I assemble my scripts using a script generation script 😉
June 11, 2012 at 1:09 am
here are some other refs ( Gail showed you _the_ one 😉 )
- see topic "Restoring a Filegroup From a Full Backup" at http://sqlserverpedia.com/wiki/Restoring_File/Filegroup_Backups
- Of course there is always Books...
June 10, 2012 at 11:57 am
I would start making the current log-backup of that database !
Then it should be able to get you to the current state, starting from your previous full backup.
If you can,...
June 9, 2012 at 12:49 pm
1) there is no column store index with SQL2005 !
2) SQL2012 column store indexes turn your table in read-only mode !
June 6, 2012 at 11:45 pm
Did you try to find the issue in the data using the isdate function ?
select Datecol, ISDATE(Datecol)
from yourtable
where ISDATE(Datecol) = 0
June 6, 2012 at 11:42 pm
I see in your example triggers all on table_1, you're only updating table table_2 in the first one.
For that one, I would use
...UPDATE cs
...
June 3, 2012 at 4:03 am
Did you try using a left join ?
SELECT completed_count = sum(case r.respondent_status_id
...
May 25, 2012 at 12:55 am
That may be a GUI problem.
Can you try the script I've attached ?
It will generate a restore using the given path ( use a fully qualified name please ) using...
May 23, 2012 at 2:31 pm
and of course, your function causes any indexes defined on that column not to be used as efficient as possible, if used at all.
No doubt, change the code or buy...
May 21, 2012 at 2:36 pm
TheSQLGuy (5/21/2012)
Note that Instant File Initialization does not work when you are using TDE. See msdn.microsoft.com/en-us/library/bb934049.aspx for more info.
Good remark.
That restriction, of course, also goes when restoring a...
May 21, 2012 at 2:29 pm
Indeed.
Instant File Initialization will kick in on database create as well as a direct db restore.
As Robert stated, there may even be a cutt off of your restore time...
May 21, 2012 at 10:38 am
Viewing 15 posts - 1,351 through 1,365 (of 7,498 total)