Viewing 15 posts - 241 through 255 (of 920 total)
Couldn't you also do something like:
select cast([Full Name] as nvarchar(255)) as [Full Name],
cast(sum([Total Activities]) as float) as [Total Activities]
into [Test]
from where_ever_the_data_is
August 22, 2012 at 2:10 pm
Do you really need that many indexes? I've seen scenarios where that was appropriate, but they were few and far between.
August 21, 2012 at 3:22 pm
What do you get when you run:
Select User.UserName,User.UserID
From User Join
Acc On User.CID = Acc.ID;
August 20, 2012 at 1:07 pm
Check out the EAV stuff I mentioned before, or better yet, try and reproduce a complex current query with the one-table design and it may become obvious how quickly the...
August 17, 2012 at 4:44 pm
You might look up EAV (Entity-Attribute-Value) model. There are lots of good opinions and article about the complexities and pitfals of the paradigm. Tough to opimize, join complexity...
August 17, 2012 at 3:52 pm
22 minutes for 10,000 rows? You have another problem somewhere. That should be closer to 22 seconds for 10,000 rows.
How big are the rows? Is there a...
August 17, 2012 at 3:09 pm
I'd try to map to public, but it's up to you. I'd test it out myself, but I'm not in a place where I can do that now. That...
August 3, 2012 at 3:27 pm
The real question would be, "do you really need an index on the notes column?". Do you search on this often? Do you search on it without some...
August 3, 2012 at 2:33 pm
On the user mapping tab, map the user to the public role in the default database and try the login again.
Sorry, hit 'enter' twice...
August 3, 2012 at 2:15 pm
On the user mapping tab, map the user to the public role in the default database and try the login again.
August 3, 2012 at 2:14 pm
OK, I'm stumped. Can you send screenshots of the login properties tabs for that login, including the roles display for the default database?
August 3, 2012 at 1:08 pm
What tool are they using to connect? Is it going through an ODBC or other type of connection that might specify an incorrect database. What happens if they...
August 3, 2012 at 12:39 pm
Might there be another group with this same set of users that is actually being used to log them in? I don't know how SQL Server figures out which...
August 3, 2012 at 12:12 pm
Does the error log show the failed login? Does the group have at least 'public' role in master?
August 3, 2012 at 11:26 am
What's the actual error message that used Z is getting?
August 3, 2012 at 11:02 am
Viewing 15 posts - 241 through 255 (of 920 total)