Viewing 15 posts - 7,366 through 7,380 (of 49,552 total)
Yes you can.
Drawbacks?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2014 at 2:14 pm
M Joomun (10/29/2014)
Ed Wagner (10/29/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2014 at 6:35 am
Matthew Darwin (10/29/2014)
Does it duplicate the LOB data
Yes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2014 at 6:27 am
Well you need something that has all dates in it that you can join to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2014 at 1:20 pm
Viewing 15 posts - 7,366 through 7,380 (of 49,552 total)