Viewing 15 posts - 2,821 through 2,835 (of 7,191 total)
I'm not sure he's doing backups at all. That's most likely to be what the problem is, and the reason I recommended getting a DBA or reading up on...
January 26, 2016 at 9:45 am
If you're not a DBA, then I strongly recommend you get one involved. If you don't, you could end up compromising availability (as you've already seen) or, worse still,...
January 26, 2016 at 8:52 am
Have you followed the advice given in the error message? What is the recovery mode for your database, and what backups do you do?
John
January 26, 2016 at 7:30 am
Have you tried CONVERT? Use REPLACE as well if you need to change spaces into hypens, and UPPER if the whole month portion needs to be in capitals.
John
January 25, 2016 at 5:57 am
That's one of the fringe benefits of SSIS - it gives you the opportunity / forces you (delete according to your own experience) to learn other things. Everything I...
January 25, 2016 at 3:21 am
If you're using SSIS, you don't need to restrict yourself to T-SQL solutions. You'll probably find it easier to run a simple Powershell (or other scripting language) command to...
January 25, 2016 at 3:09 am
Does it take that long every single time? Have you tried using sp_whoisactive or similar to find out what is going on during the SET OFFLINE operation?
John
January 25, 2016 at 2:54 am
What do you mean? Please show us what you have tried, and we'll try to show you where you're going wrong.
John
January 21, 2016 at 5:55 am
You need the DENSE_RANK function. Give it a try, and post back if you're struggling.
John
January 21, 2016 at 5:21 am
salardx (1/21/2016)
the software needs to extract some aggregated reports for the owners! so having 10,000 tables is the best approach!
Please can you explain the causal link between the need to...
January 21, 2016 at 4:25 am
150GB isn't a huge amount of storage these days. But in your original post, you were talking about "a table", and now you're talking about 10,000. Do all...
January 21, 2016 at 3:53 am
river1 (1/20/2016)
It will be easyer then having to select each one from the diagram or having to look at the reports, one by one...
If you right-click on the database name,...
January 20, 2016 at 5:06 am
If you post sample data that agrees with the result set, then you get a fully tested solution. I'm not comfortable coming up with something and then not being...
January 19, 2016 at 7:32 am
OK, if the question is how do you get the result set you posted based on the sample data you posted, then the answer is I don't know. Maybe...
January 19, 2016 at 4:51 am
If you're after server level permissions, query these two views:
sys.server_permissions
sys.server_role_members
If it's database level permissions you need, query these views:
sys.database_permissions
sys.database_role_members
Have a try at that, and please post back if there's anything...
January 19, 2016 at 4:12 am
Viewing 15 posts - 2,821 through 2,835 (of 7,191 total)