Viewing 15 posts - 571 through 585 (of 956 total)
You don't use the data file, you specify a connection to the Server.
Open View -> Server Explorer.
Right click on Data Connections -> Add Connection.
Select...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 5:11 pm
RBarryYoung,
Just curious why you don't use DBNull.Value? The other thing would be to set a default value in the SP to null as in:
create procedure insertproc
(
@datetimevar datetime = null
)
and...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 7, 2009 at 5:07 pm
Noel,
If you feel sporty one time, try the rebuild for one table over the update stats command. From everything I am getting it is going to be faster with...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 6, 2009 at 9:39 am
You might also reconsider your security model and the permissions people have if you are having an issue with something like a column being added to a table and no...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 6, 2009 at 9:36 am
The best bet to get a true answer to this question is call the licensing folks at:
Licensing –Microsoft, Contact
(800) 426-9400
I would think the answer is no, but I am...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 6, 2009 at 9:33 am
Lynn Pettis (12/26/2008)
Actually, no I haven't. A friend of mine did some research and it seems that there have been a few others that have had similiar issues with...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 6, 2009 at 9:28 am
noeld (1/6/2009)
On VLDB you should NEVER run DBCC CHECKDB because it does simply too much. You can split the checks (ALLOCATION only, CHECKTABLE only, PHYSYCAL only, etc ...) or...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 6, 2009 at 9:22 am
Jim Johnston (1/5/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 4:39 pm
I can ask Paul Randal to answer that. I don't know what a good answer would be to be perfectly honest, but my gut says no.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 4:33 pm
MAXDOP only applies to Rebuilds and not reorganizations. Reorganization is supposed to be a single threaded operation so an CXPACKET Wait that you get will be what you get...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 2:11 pm
What version of SQL Server is this for?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 1:39 pm
GilaMonster (1/5/2009)
Jonathan Kehayias (1/5/2009)
GilaMonster (1/5/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 1:25 pm
Don,
Have you resolved this, and if not, what is the table/index definition for employees? Is there an index on the clientid column and what is the datatype for that...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 12:34 pm
GilaMonster (1/5/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 12:29 pm
It would make an interesting article to write up anyway. If I get it complete, I'll PM you the code that way Steve can publish it as an article...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 12:21 pm
Viewing 15 posts - 571 through 585 (of 956 total)