Viewing 15 posts - 2,821 through 2,835 (of 7,187 total)
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
The values in the ReportingGroup column in your sample data don't match up with those in the same column in your result set. Am I missing something, or have...
January 19, 2016 at 4:08 am
Right, I think I understand now. Please will you post some sample data (INSERT statements again) that will yield the results you're looking for.
Thanks
John
January 19, 2016 at 2:44 am
No, still not clear. You say you want to concatenate ReportingGroup, but your sample results only show one value per row in that column. And I'm afraid I...
January 19, 2016 at 2:10 am
Charmer (1/18/2016)
I know John, Performance will be affected. But I have no other option.
Never mind performance - how are you going to display a minimum of 12,000 characters in your...
January 18, 2016 at 6:58 am
Viewing 15 posts - 2,821 through 2,835 (of 7,187 total)