Viewing 10 posts - 121 through 131 (of 131 total)
How about a CTE like this one?
create table #EmpDaysOff(
EmpID varchar(5)
,Code varchar(5)
,FromDate datetime
,ToDate datetime)
insert into #EmpDaysOff(EmpID, Code, FromDate,ToDate)
select 'A', 'Hol', '20121015','20121017'
union all select 'B', 'Hol', '20121015','20121017'
union all select 'C', 'Hol', '20121017','20121019';
with...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 17, 2012 at 10:11 am
If the records in history have the same date without a timestamp there needs to be a unique way to identify the latest record. If RecID is sequential then...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 17, 2012 at 8:54 am
Here's a tweak to the code above to get rid of the error...
still not sure how to get your 2nd requirement to concatenate the 2 dates if they're on the...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 17, 2012 at 8:19 am
I wish I knew.. the only thing I know is that the application that uses the database is written in VB 6.0 and it allowed users to create objects in...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
October 12, 2012 at 9:35 am
Regarding what happens to data from 00.00 to 00.10 depends on your backup timeframe... if u backup every 5 minutes then you'll have a t-log backup file @ 00.05 and...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
August 24, 2012 at 9:32 pm
The secondary DB will be 00.00 since that was the log file that was restored from the primary log backup. Secondary will always be behind primary and since the...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
August 24, 2012 at 9:22 pm
I've noticed sometimes that on new cluster setups the servers will lose the drive letter or even use a different one when you failover, especially with iSCSI connections. check...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
August 24, 2012 at 9:09 pm
If your backup script is using the native "Backup Database" then it's not... Litespeed backup scripts are different something like "Litespeed.exe -d..." something like that... it's been 6 months since...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
August 24, 2012 at 9:01 pm
How about using SSIS to pull the data from all the sql instances and send an excel document from it?
Maybe setup a table with all the server names and then...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
August 24, 2012 at 8:47 pm
Any new processes scheduled to run during the backup period? If the overall size of the DB is the same and the type of data remains the same it...
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
August 9, 2012 at 7:39 am
Viewing 10 posts - 121 through 131 (of 131 total)