Viewing 15 posts - 29,071 through 29,085 (of 39,771 total)
There is no reason to design the columns in any order. As far as I know, it's not a best practice to make them alphabetical, or any other order.
There's no...
March 31, 2008 at 7:36 am
The notmatched rows come from your initial CTE (or SELECT) from what I understand.
My understanding was that you write a SELECT, which is the input into MERGE. The MERGE then...
March 31, 2008 at 7:34 am
Are you backing up the log regularly? Maybe try right before the reindex?
The reindex should use 1.5-2x the data space and it's logged, so there's movement, but I wouldn't expect...
March 31, 2008 at 7:32 am
Sorry typo in the gas savings. It should have been $2125. I'm not blinded either. I am comparing it to the last van we had, 2004 Honda that said 25,...
March 31, 2008 at 7:25 am
If you're starting out, I think a BS/BA helps. It shows you can complete a long project and get work done. Doesn't help you to learn SQL Server, and no...
March 30, 2008 at 3:17 pm
this is a connection error; are you getting this when you try to connect or when you start the service?
March 30, 2008 at 10:24 am
http://www.sqlservercentral.com/articles/Advanced+Querying/tamethosestringspart7/390/
FYI, be careful of using triggers for this. You might cause lots of unnecessary work and this will have to run for every insert/update. You might want to set up...
March 28, 2008 at 10:54 am
You are not setting up a maintenance plan if you right click the database. While that might make sense, what you are setting up is an ad hoc backup.
go to...
March 28, 2008 at 10:52 am
Please post a question that makes sense. Do not use the subject line as your question and give details about what specifically you are concerned about.
March 28, 2008 at 10:51 am
Karl has a pretty good summary of what to worry about and what advice I'd give.
March 28, 2008 at 10:49 am
Votes matter on Connect, so I'd actually suggest a few things.
1. Post on Connect
2. Make a post in the appropriate forum here and state your care, and link to the...
March 28, 2008 at 10:35 am
Interesting answers, and with these new Mission-Impossible-3D printers, I think I'd avoid biometric data as well.
Here in the US, there are starting to be some devices that work off fingerprints,...
March 28, 2008 at 9:54 am
Neither is necessarily better. If you have a view, you can create the view and apply a filter in the WHERE clause that limits data.
Perhaps you should try a few...
March 27, 2008 at 2:13 pm
May or may not have any impact. Are you using the IPs to connect?
Network changes do not necessarily change anything for SQL Server.
March 27, 2008 at 11:02 am
Viewing 15 posts - 29,071 through 29,085 (of 39,771 total)