Viewing 15 posts - 2,101 through 2,115 (of 6,401 total)
New Born DBA (10/5/2015)
Any help on this?
Have a go at writing a loop to run the query I posted for each DB you have on your server, one thing to...
October 6, 2015 at 1:23 am
djj (10/5/2015)
anthony.green (10/5/2015)
TomThomson (10/5/2015)
whereisSQL? (10/5/2015)
crookj (10/5/2015)
anthony.green (10/5/2015)
Ed Wagner (10/5/2015)
djj (10/5/2015)
anthony.green (10/5/2015)
Ed Wagner (10/5/2015)
anthony.green (10/5/2015)
SQLRNNR (10/4/2015)
ghoul-ashUno
Cards
House
Boat
Fishing
Tackle
Guard
Defense
Attack
Block
Stone
Cutters
October 5, 2015 at 8:46 am
IIRC you need to restart the instance after the restore. Might be tricky with Always On, might have to take all the servers offline.
October 5, 2015 at 8:45 am
TomThomson (10/5/2015)
whereisSQL? (10/5/2015)
crookj (10/5/2015)
anthony.green (10/5/2015)
Ed Wagner (10/5/2015)
djj (10/5/2015)
anthony.green (10/5/2015)
Ed Wagner (10/5/2015)
anthony.green (10/5/2015)
SQLRNNR (10/4/2015)
ghoul-ashUno
Cards
House
Boat
Fishing
Tackle
Guard
Defense
Attack
Block
October 5, 2015 at 8:08 am
Ed Wagner (10/5/2015)
djj (10/5/2015)
anthony.green (10/5/2015)
Ed Wagner (10/5/2015)
anthony.green (10/5/2015)
SQLRNNR (10/4/2015)
ghoul-ashUno
Cards
House
Boat
Fishing
Tackle
October 5, 2015 at 6:25 am
devesh.hassani (10/5/2015)
Table schema is below. It contains three columns onlyColumn AColumn BColumn C
XXXXXXXX64856Test001
XXXXXXXX64857Test002
Please see the link in my signature on posting code and data for the best help.
E.g, your sample...
October 5, 2015 at 5:57 am
Ed Wagner (10/5/2015)
anthony.green (10/5/2015)
SQLRNNR (10/4/2015)
ghoul-ashUno
Cards
House
October 5, 2015 at 5:29 am
Its the usual DBA answer of "it depends", it all goes on how the infrastructure will be built and how you want to do HA/DR
As with anything as complicated and...
October 5, 2015 at 5:17 am
As all the hosts in the SQL hyper visor pool are licensed it doesn't matter about VM movement as they move between hosts that are fully licensed.
October 5, 2015 at 4:47 am
We license both DC's with enterprise edition at the hyper visor level to give us unlimited visualization rights across the compute power of the hosts, this is dramatically cheaper than...
October 5, 2015 at 4:04 am
Something like this
CREATE TABLE #Temp (ParentObject VARCHAR(100), Object VARCHAR(100), Field VARCHAR(100), Value VARCHAR(100))
INSERT INTO #Temp
EXECUTE ('DBCC DBINFO (''YourDBNameHere'') WITH TABLERESULTS')
select
distinct
'Last Known Good DBCC CHECKDB',
Value,
datediff(day,convert(datetime,value),getdate()) AS DayDifferenceFromToday,...
October 2, 2015 at 8:41 am
whereisSQL? (10/2/2015)
crookj (10/2/2015)
anthony.green (10/2/2015)
eccentricDBA (10/2/2015)
anthony.green (10/2/2015)
BWFC (10/2/2015)
anthony.green (10/2/2015)
SQLRNNR (10/1/2015)
pishannoyed
Always
Developers
Tycoons
Zoo
...lander
Movie
Trivia
October 2, 2015 at 8:14 am
Out of memory popups in SSMS? The App?
Please post screenshots.
Please remember we cant see what you can see, so please provide as much detail as you can.
October 2, 2015 at 8:09 am
tauseef.jan (10/2/2015)
Physical RAM on the box = 24 GbMAXmemory allocated to SQL server = 20 GB
Min memory to sql server = 512 MB.
Still SQL server is freezing.
How is SQL...
October 2, 2015 at 8:01 am
Viewing 15 posts - 2,101 through 2,115 (of 6,401 total)