Viewing 15 posts - 12,406 through 12,420 (of 39,936 total)
Luis Cazares (6/14/2013)
The question is interesting but I do wonder why would someone would disable a clustered index?
ETL loads is one reason. It can be faster to load without indexes...
June 14, 2013 at 12:53 pm
It's not quite clear what you mean, or what you did for access.
What did you do to grant access.
When you say he gets an error, do you mean he...
June 14, 2013 at 8:07 am
My apologies. I think I cut and pasted the drop in the wrong spot when this was proofed. It definitely ran correctly when it was tested.
I will award points back...
June 14, 2013 at 8:05 am
wolfkillj (6/14/2013)
You got close, Rod, and we'll give you a pass since you're not American.
Here's the lineup:
1st base: Who
2nd base: What
3rd base: I Don't Know
Left field: Why
Center field: Because
Pitcher:...
June 14, 2013 at 8:02 am
First, you probably should have someone else responsible for setting this up or working with you. Encryption is serious business and if you lose keys, you lose data. Microsoft...
June 13, 2013 at 3:45 pm
There is a percent complete column, where you can get the progress. In terms of the rate, you'd have to just watch this and calculate something.
SELECT
db.name,
...
June 13, 2013 at 3:07 pm
Do you have lots of free space in your databases?
In terms of the object, what's the way that it's structured? Is the row size significant compare to page size? Fill...
June 13, 2013 at 2:54 pm
#1, why use tempdb? It's like you are trying to make this more complex first instead of getting it working.
Do it WITHOUT ANY PATH first. Get the backup working correctly.
Then...
June 13, 2013 at 11:34 am
Roll forward - transactions committed in the log, but not written to the data files are pushed there.
Roll back - uncommitted transactions are undone from the data file.
June 13, 2013 at 11:08 am
Visualizations are a great place to start, but not sure they're often good for decisions. Better to dig in further to the data itself and verify with the details. however...
June 13, 2013 at 10:01 am
You could use encryption in SQL Server 2008 to encrypt the data before it's exported to the file. however if you are attaching a file dropped on your file system,...
June 13, 2013 at 9:58 am
If your master key is not protected by the service master key, you need to open it. Since I don't know how you configured your encryption piece, you may need...
June 13, 2013 at 9:01 am
The Dixie Flatline (6/13/2013)
Brandie Tarvin (6/13/2013)
The Dixie Flatline (6/13/2013)
Don't talk to me about time. Time is my business.
Dixie, I could kiss you for this. @=)
By the way, does...
June 13, 2013 at 8:21 am
The error is what it says, you are missing part of the media family. This is a striped backup, and you can do this natively in SQL Server.
In Backup Pro,...
June 12, 2013 at 1:40 pm
A few thoughts here.
I have no idea on the uninstall and active v in active licenses. I would guess that it's installed licenses, so there is no concept of active/inactive...
June 12, 2013 at 1:38 pm
Viewing 15 posts - 12,406 through 12,420 (of 39,936 total)