Viewing 15 posts - 61 through 75 (of 394 total)
We also have a number of SS2005 Std Edition production databases with active services running against them. So we have a Saturday night maint window when services are being brought...
February 24, 2012 at 6:28 pm
Exit SSMS completely ( all open SSMS sessions if any) and then start a new session in SSMS. If not detached already, then run your detach again. That should...
January 10, 2012 at 4:56 pm
make sure to do a failover on the other node and then test your backup job using LS (and vise versa)
November 30, 2011 at 5:45 pm
Our users have read-only access to all prod environments. At the same time our DBA team provide 24/7 support in all prod environments-meaning each valid prod request ( after getting...
October 12, 2011 at 6:06 pm
Install SQL Server Dev Edidtion at work, get the book(s) and start making little projects. Spent 3-6 months on that. Once you achieve some level of confidence, you might want...
September 20, 2011 at 6:57 pm
Maybe that will get you going:
if (select OBJECT_ID('tempdb..#tab')) is not null drop table #tab
Create table #tab (TABLE_SCHEMA sysname,TABLE_NAME sysname,COLUMN_NAME sysname,Row_Number int primary key)
if (select OBJECT_ID('tempdb..#tab2')) is not null drop table...
August 24, 2011 at 5:26 pm
Declare @FileName varchar (100)
Set @FileName ='12304208348300'
SELECT REPLACE(Left(Convert(Varchar,Convert(Money,@FileName),1),Len(Convert(Varchar,Convert(Money,@FileName),1)) - 3),',','.')
12.304.208.348.300
Not sure what the problem was?
I know that this code has limitations, but for the values specified earlier in the thread it...
July 18, 2011 at 10:43 am
Declare @FileName varchar (100)
Set @FileName ='12304208483483'
SELECT REPLACE(Left(Convert(Varchar,Convert(Money,@FileName),1),Len(Convert(Varchar,Convert(Money,@FileName),1)) - 3),',','.')
July 15, 2011 at 6:42 pm
It is OLE DB/.NET connection, not OLAP. This is a simple data connection to a database...
July 13, 2011 at 5:14 pm
Different industries pays different salaries, so in insurance company you probably will get paid less then in trading\hedge fund based on the same experience...
July 12, 2011 at 12:42 pm
Just tell a starup-if they can work out on stock option for you, I probably would go. Just remember that you can realized it at liquadation event , which could...
July 9, 2011 at 9:12 pm
Don't think it is a good idea, especially when it comes to clusters. Used to have a lot of issues in the past with only one node being updated. Additionally...
June 27, 2011 at 6:13 pm
You may want to sit with a Senior DBA and discuss all issues (SQL related) that used to happened before you in this organization. And how they were resolved. Make...
June 1, 2011 at 5:05 pm
Maybe that could help. That worked with non-IT personel before.
It is like apartment (Database) in the apartment building (Server).
Each Apartment Building (Server) has multiple apartments (Databases).
So in order to get...
February 9, 2011 at 6:00 pm
I wouldnt say it is useless. I heard of some companies which require some kind of certification. So if you have time I would do both: work on passing exam...
February 4, 2011 at 4:13 pm
Viewing 15 posts - 61 through 75 (of 394 total)