Viewing 15 posts - 31 through 45 (of 308 total)
Koen Verbeeck (6/30/2015)
DBA From The Cold (6/30/2015)
I've...
June 30, 2015 at 2:47 am
Hey guys, going a bit off topic here but would like some advice please as I know pretty much all of you are writers/bloggers.
I've had a blog post copied word...
June 30, 2015 at 2:38 am
Hmm, I'm guessing but I would imagine that the table was initially designed with the clustered index and then at some point someone wanted to enforce some form of business...
June 29, 2015 at 10:38 am
OK so I've run through this on my dev instance.
DISCLAIMER - Please don't run this without testing it first (I know you won't but just need to say it :-)...
June 23, 2015 at 6:59 am
Jeff Moden (6/22/2015)
Welsh Corgi (6/22/2015)
DBA From The Cold (6/22/2015)
Depending on how your...
June 23, 2015 at 1:54 am
You'd need to create the required partition schemes/functions and then rebuild your tables' clustered index onto the partition scheme.
Depending on how your table is built you would also have to...
June 22, 2015 at 10:43 am
Please let me know if this is a bad idea but what I'd do is....
Make sure there is space available on the disk.
Take the database offline
Bring the database back online
If...
June 12, 2015 at 6:49 am
I thought that 112 was not enough space on disk?
June 12, 2015 at 6:44 am
Can you post the statement where you are using the THROW clause?
June 12, 2015 at 6:36 am
I'm honestly not sure how to do that with xp_cmdshell.
What are you trying to do?
June 12, 2015 at 6:29 am
OK, so as Gail said go through the error log and post all messages that you can find relating to that db.
We need to find out why the database has...
June 12, 2015 at 6:28 am
I wasn't suggesting that you restart the server, I was just wondering if it had been to send the database into the recovery pending mode.
Have you tried copying the MDF...
June 12, 2015 at 6:19 am
If the database is in the recovery pending state then something has happened that is preventing the recovery process from starting.
Has the server been restarted?
June 12, 2015 at 5:54 am
If you need to do some logic you could use:-
$filepath = "C:\Temp"
$date = "2015/06/06 03:50:00"
$files = gci $filepath | select-object name, lastwritetime, creationtime
foreach($file in $files)
{
$fileCreateDate =...
June 12, 2015 at 5:32 am
This powershell script will do that:-
$filepath = "C:\Temp"
gci $filepath | select-object name, lastwritetime, creationtime
Is that what you needed?
June 12, 2015 at 5:27 am
Viewing 15 posts - 31 through 45 (of 308 total)