Viewing 15 posts - 2,761 through 2,775 (of 7,498 total)
If I'm correct, any restore database command will disable SSB for the restored db.
It is up to you to double check if the SSB guid for the db is still...
October 15, 2010 at 7:37 am
GilaMonster (10/14/2010)
CirquedeSQLeil (10/14/2010)
That's quality entertainment
Yup.
Currently watching them test to see if a cup of soda can kill you through a windscreen if thrown while cars travelling at highway speed. Actually...
October 15, 2010 at 2:37 am
- can you repro the situation ? (DDL ?)
- can you post the actual tsql you tried ?
(and their results)
- what's the relation between the service account and the...
October 14, 2010 at 11:47 am
did you try "sp_changedbowner newlogin, true" ?
October 14, 2010 at 11:28 am
The maint plan has the "statistics only" option.
Otherwise you might be using something based on:
select 'UPDATE STATISTICS ' + quotename(object_schema_name(object_id)) + '.' + quotename(object_name(object_id)) + ' ' + quotename(name)...
October 14, 2010 at 11:21 am
Don't they come with solar cells on the back ... euhm top ...:alien: ????
October 14, 2010 at 10:50 am
GilaMonster (10/14/2010 11:06 AM)
ALZDBA (10/14/2010)
GilaMonster (10/14/2010)
... *hopeful* *optimistic* ...DBA-part taking over :w00t:
Developer-side. My DBA side is extraordinarily pessimistic
...
GilaMonster (10/14/2010 11:15 AM)
ALZDBA (10/14/2010)
GilaMonster (10/14/2010)
... *hopeful* *optimistic* ...DBA-part taking over :w00t:
Developer-side. My...
October 14, 2010 at 3:29 am
GilaMonster (10/14/2010)
... *hopeful* *optimistic* ...
DBA-part taking over :w00t:
October 14, 2010 at 2:52 am
With 64 bit it is advised you set the max server memory for sqlserver !
Set the sqlserver configs "max server memory" to the value you allow it to take...
October 13, 2010 at 2:54 pm
GilaMonster (10/12/2010)
The Dixie Flatline (10/12/2010)
Modest proposal for you, Gail: Take your katana and wakazashi to the next meeting.
Oh this wasn't a planned meeting. This...
October 13, 2010 at 1:02 am
There are multiple "split string" tvf functions you can find at SSC. Just use its search feature.
Just add an identity column to the result table and join on that.
October 10, 2010 at 9:04 am
Congratulations SSC !
Thank you for providing _the_ reference platform for SQLserver and the means to learn on a daily basis !
October 9, 2010 at 12:18 pm
There are multiple articles at SSC that may be of your interest:
- Generating Missing Dates and Numbers By Jacob Sebastian http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/
- The "Numbers" or "Tally" Table: What it is and...
October 6, 2010 at 1:59 pm
I mostly use SQLServer Management Studio to get to my SQLServers.
But I'm a dba and rarely developer.
With regards to your Access conversion:
- Keep in mind Microsoft has a tool that...
October 6, 2010 at 7:16 am
raid is not mandatory !
However .... if you have no raid volume for your sqlserver databases, it is game over if you lose the drive, where with e.g. a raid1...
October 5, 2010 at 3:47 pm
Viewing 15 posts - 2,761 through 2,775 (of 7,498 total)