Viewing 15 posts - 1,201 through 1,215 (of 1,318 total)
Rebuilding indexes is basically like dropping them and recreating them, and it's a fully-logged process, which is why it bloats your transaction log.
Keith has given you good advice there.
December 9, 2013 at 8:29 am
In case anybody stumbles across this one day and also needs the answer, it turned out to be a firewall issue. Opening port 1433 resolved the problem.
November 27, 2013 at 5:52 am
I've seen good salaries advertised for data architects. It's not necessarily a promotion though, as already mentioned.
November 27, 2013 at 5:12 am
i have 2 yrs data in my database can i backup last yr data only??
if possible
Not unless it's already in a specific file, I don't think: http://technet.microsoft.com/en-us/library/ms179316%28v=sql.105%29.aspx
whenever i want...
November 27, 2013 at 2:58 am
Hello again. Ok, I've made quite a lot of progress on this now, but please could somebody tell me this if they know?
If I test the connection (right-click on linked...
November 21, 2013 at 4:05 am
so he's not using a SQL login, but rather a windows login [MyServer\jobloggs]( or is it really [MyDomain\jobloggs]?)
No- see what I said above:
He logs into my server (A) with...
November 20, 2013 at 8:43 am
I can't really advise because I'm fairly new to the game myself, but one thing to do would be to look at job adverts and see what skills they're asking...
November 20, 2013 at 8:30 am
finally, you add the linked server on server A, and make sure you use the mapping idea fromt eh screenshot: login not defined = not be made, and map your...
November 20, 2013 at 8:12 am
Thanks for replying.
Lowell (11/20/2013)
does his windows login credentials work for the linked server?
He logs into my server (A) with a local account on that server. (This is because he's...
November 20, 2013 at 6:26 am
Thanks, that's what I thought.
November 20, 2013 at 3:38 am
Just seen this blog post, which I thought was timely.
Members of the local Administrators group can still login to SQL Server. With full sysadmin privileges. How? By impersonating...
November 18, 2013 at 5:15 am
regProgrammer (11/18/2013)
- If I backup my transaction log, do I also then need to shrink it the log?
I'd look at managing the growth by backing up your log...
November 18, 2013 at 3:16 am
Viewing 15 posts - 1,201 through 1,215 (of 1,318 total)