Viewing 15 posts - 2,896 through 2,910 (of 18,926 total)
ps. (9/8/2011)
Thanks for the script Remi. I had written one but this is better. Copied and saved for future use 😉
Don't forget to give references.
I did and now...
September 8, 2011 at 10:37 am
I should preface all my messages with.
I'm a moron, don't listen to me. Anything I say can destroy your servers and have you fired for doing what a clown...
September 8, 2011 at 10:35 am
ps. (9/8/2011)
GilaMonster (9/8/2011)
Restoring over an existing database that is in use? If so, the restore can't even start until exclusive access is obtained on the DB.
SQL throws error message for...
September 8, 2011 at 10:31 am
chris.mcgowan (9/8/2011)
It ships with SQL Server 7 and 2000 and is an undocumented executable. Link to resource below;http://www.sqlserverclub.com/articles/use-scptxfr-to-schedule-sql-server-database-creation.aspx
Thanks
Chris
I must be blind, I don't see a download button for the...
September 8, 2011 at 10:30 am
Never tried that.
Have you tested and IIF? You could control the value there and it should be possible to make it work.
September 8, 2011 at 10:28 am
GilaMonster (9/8/2011)
Restoring over an existing database that is in use? If so, the restore can't even start until exclusive access is obtained on the DB.
Ya but doesn't that error out...
September 8, 2011 at 10:26 am
Gianluca Sartori (9/8/2011)
Ninja's_RGR'us (9/8/2011)
I'm not 100% sure here but I really don't think that tempdb is a perfect copy from model.Interesting question. One possible answer here:
Pretty much what I was...
September 8, 2011 at 10:25 am
Gianluca Sartori (9/8/2011)
Krasavita (9/8/2011)
I get one result, can you explain to me,how I can understand what I should get to know that is is bad for tempdb
High values for...
September 8, 2011 at 10:22 am
Lowell (9/8/2011)
Ninja's_RGR'us (9/8/2011)
How big is the log file in the restored DB? That file needs to be 0 initialized and that takes time.http://sqlskills.com/blogs/Kimberly/post/Instant-Initialization-What-Why-and-How.aspx
ahh, yeah zeroing out the log file...
September 8, 2011 at 10:20 am
SQLRNNR (9/8/2011)
Sad reality 😎
Then they wonder why it doesn't work and why it takes longer than requested and costs more than negociated. Also why we don't want to come...
September 8, 2011 at 10:19 am
ally.john2 (9/8/2011)
How can I get chosen Report Name value into ReportName1 parameter ?(Please see second attachment)Thanks
Ally
Please stop editing the original post, it justs makes it hard to understand the...
September 8, 2011 at 10:17 am
Wow, so 50% savings is possible. I'll keep that in mind when are backups become too slow.
Thanks.
September 8, 2011 at 10:15 am
Lowell (9/8/2011)
I believe it can take time for the operating system to find 120 gig of as-contigous-as-possible...
September 8, 2011 at 10:10 am
ally.john2 (9/8/2011)
Sorry I should have put chosen instead of current.
Go to the properties of any textbox you want to become a link.
Then action, hit ... to get the popup.
From...
September 8, 2011 at 10:08 am
That will show you the progress :
SELECT r.[session_id]
, c.[client_net_address]
, s.[host_name]
, c.[connect_time]
, [request_start_time] = s.[last_request_start_time]
, [current_time] = CURRENT_TIMESTAMP
,...
September 8, 2011 at 10:04 am
Viewing 15 posts - 2,896 through 2,910 (of 18,926 total)