Viewing 15 posts - 29,881 through 29,895 (of 39,769 total)
I think you mean "no one is disrespecting"
That's a good example of where mis-communications occur. It is important to try and learn from your mistakes when you're working in another...
January 13, 2008 at 9:03 pm
Tony,
thanks and glad you like them. I'll try to keep them coming and hopefully pick interesting topics.
January 13, 2008 at 8:53 pm
You could script out the indexes, save this. Then do a search and replace for the indexes, choosing the new filegroup as the new location.
January 13, 2008 at 8:50 pm
Mixed mode means you can use either SQL or Windows authentication. It doesn't mean you are using one or the other.
If you are using SQL authentication, you can only base...
January 13, 2008 at 8:49 pm
Anytime. I am usually busy, so I don't worry about the stuff that isn't being queried. Who knows how many tables are old, never deleted, out of date, etc. Same...
January 13, 2008 at 8:43 pm
I'm with Jeremy. I'm sure there's a good set based way to do this, but to just get it done, I'd rip through the table based on time and process...
January 13, 2008 at 8:38 pm
It's not completely clear what results you are looking for and what the data means from your explanation. Please clarify with a simpler example using the fields you need and...
January 13, 2008 at 8:36 pm
You can use Local System, but if you do need to access, the network, don't put the service account into the admin group. Instead create a regular user account, no...
January 13, 2008 at 8:33 pm
Is there anything ever written to the SQL Server error log or the Windows Event Log?
It's strange to see this type of error. I have no idea why you'd be...
January 13, 2008 at 8:31 pm
January 13, 2008 at 8:28 pm
Mark,
Thanks and I understand the reasons, but it's still something that I never have come across in the SQL Server documentation. I wanted to point it out to be sure...
January 13, 2008 at 8:26 pm
I'd probably use some type of replication to move data around, but I'm more comfortable with that. If you're comfortable with Perl or DTS, use that.
You need to track down...
January 13, 2008 at 8:25 pm
If you have DB1, DB2, DB3, I'd recommend you create a view for each table.
In DB1, create view db2Employee as select * from db2.dbo.Employee.
Also, create view db3Employee as select *...
January 13, 2008 at 8:22 pm
Viewing 15 posts - 29,881 through 29,895 (of 39,769 total)