Viewing 15 posts - 106 through 120 (of 153 total)
Powershell would work.
You could read first line until crlf - that would give you the format of your file, then use some string processing in Powershell to build...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 6, 2013 at 5:47 pm
Hi Thanks for reply!
Does the purged table have a clustered index?
Yes there is a clustered index, this is one in vendor custom job/stored proc that rebuilds the index using...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 6, 2013 at 5:40 pm
I saw your post... though I don't think I have an answer, I did have questions?
Just wanted to confirm:
Post mentioned there was nothing in the bootstrap logs? (I'm...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
November 15, 2012 at 7:17 pm
Anyone know of a website "App" or app for SQL Server tech articles ..or (magazine/newspaper style?) - like they do for "news" consolidation. There are some no the iPad...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
November 15, 2012 at 1:24 pm
Agree with Randy they potentially could be on non default port for your SQL Servers. (e.g. named instance possibly)
Have you tried using a tool to check the ports?
Microsoft has...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
November 15, 2012 at 1:22 pm
Could it be that SQL Browser services needs to be active so that oSQL will see servers. Also you may want to check if your firewall settings have blocked...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
November 14, 2012 at 2:23 am
I agree with Arthur, I like the magazines also. I do like SQL magazine, and really liked the print form. I guess we're saving trees now.
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
November 14, 2012 at 1:58 am
Someone already asked about drive differences so maybe I can ask something else:
Is the data in both environments the same or have you rebuilt indexes, refreshed everything, restarted sql server...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
November 14, 2012 at 1:55 am
1. Add a clustered index to each table
2. Keep indexes narrow, especially the clustered index
3. Make sure that the columns in the clustered index aren't updated
4. Make clustered indexes monotonically...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
September 21, 2012 at 3:58 pm
Hello I saw your posting, but I wanted to confirm.. you stated you have installed only the client tools successfully?
Are you stating that the SQL Server engine was not...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 21, 2012 at 1:08 am
This might not be relevant as maybe you've already tried this ... but have you looked in your add/remove programs to see if there were remnants of past SQL Server...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 20, 2012 at 6:42 pm
I removed because my suggestion was incorrect, I wasn't paying close attention - apologies Welsh Corgi... thanks for pointing out Gilamonster. 🙂
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 18, 2012 at 12:19 pm
How are you determining where the Hypens will be inserted? Do you have a spec/business rule?
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 16, 2012 at 11:32 pm
I'm wondering also if restoring the system dbs along with user dbs might work if using same machine? Do you have a way to test this, I'd...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 16, 2012 at 4:44 pm
Ah that's what I was missing! I was not considering those factors.
Thanks everyone
-Norman
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 16, 2012 at 1:19 pm
Viewing 15 posts - 106 through 120 (of 153 total)