Viewing 15 posts - 7,366 through 7,380 (of 49,571 total)
Yes you can.
Drawbacks?
October 30, 2014 at 5:32 am
Not a bug. CLR uses memory outside of the limit set by max server memory. You must have some memory-intensive CLR. Chat with the devs, make sure they're not doing...
October 29, 2014 at 2:14 pm
M Joomun (10/29/2014)
Ed Wagner (10/29/2014)
October 29, 2014 at 12:03 pm
If you have three data files in three separate filegroups, no you can't. If you restrict growth on the mdf and it's the only file in the PRIMARY filegroup, when...
October 29, 2014 at 8:00 am
Take a read through these:
http://www.sqlservercentral.com/articles/Administration/64582/
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
I suspect you have a DB in full recovery and you're not taking log backups. In that case the log will grow until it fills the...
October 29, 2014 at 7:54 am
louie1487 78804 (10/29/2014)
Can't use the remove band-aid approach. I already got shut down on that idea.
To be honest, I'd push back on this, hard.
Peer-to-peer replication is about the only thing...
October 29, 2014 at 7:04 am
ISNULL (IntegerColumnName, ReplacementValue)
The data type returned will be the 'larger' of INT and whatever the replacement value is.
btw, SQL doesn't have booleans. It has the bit data type which is...
October 29, 2014 at 6:35 am
Matthew Darwin (10/29/2014)
Does it duplicate the LOB data
Yes.
October 29, 2014 at 6:27 am
Well you need something that has all dates in it that you can join to.
October 29, 2014 at 4:10 am
Use a calendar table, left join from the calendar table to your data table (because you want all the rows from the calendar and matching rows from the data table)
October 29, 2014 at 3:27 am
Just a comment on this...
NEVER update the system tables. You can't touch them in most circumstances, it's very easy to make mistakes and break things and, by updating the system...
October 29, 2014 at 2:42 am
Why do you need to wrap that query in a distributed transaction?
Have you checked to see what error DTC is actually throwing?
October 29, 2014 at 2:31 am
jacksonandrew321 (10/29/2014)
improper shutdown of the sql server services,
Not unless the files are damaged in the process. SQL is perfectly capable of recovering from unexpected shutdowns
not enough disk space when...
October 29, 2014 at 1:05 am
Sapen (10/28/2014)
Also are there any specific causes that will take a database into suspect mode?
SQL encounters a corrupt or unreadable page while doing a transaction rollback or crash recovery. Details...
October 28, 2014 at 4:27 pm
rodjkidd (10/28/2014)
Less that 24 hours for my flight to Seattle...This album seems appropriate seeing as it took me all week last time to find him! 😀
Rodders...
My theme tune for the...
October 28, 2014 at 1:20 pm
Viewing 15 posts - 7,366 through 7,380 (of 49,571 total)