Viewing 15 posts - 6,106 through 6,120 (of 22,211 total)
SQLRNNR (5/13/2015)
Grant Fritchey (5/13/2015)
One point. i said that BLOB storage was outside the database. That's not right. Not sure where my head was. Gail spotted it and corrected me.
Maybe in...
May 14, 2015 at 12:52 am
For a point lookup (one row) against a clustered index, there really isn't a major performance hit.
But, some of the places where there are issues. First, pages in memory. By...
May 13, 2015 at 10:07 am
Also, I need a new head, FILESTREAM data is stored apart from the database, but is backed up and restored through the backup process.
May 13, 2015 at 9:57 am
One point. i said that BLOB storage was outside the database. That's not right. Not sure where my head was. Gail spotted it and corrected me.
May 13, 2015 at 7:38 am
GilaMonster (5/13/2015)
Grant Fritchey (5/13/2015)
Because you can have physical corruption that doesn't get backed up or restored.
How?
I keep hearing this advice, but the problem is it doesn't bear out. Backups are...
May 13, 2015 at 7:32 am
Because you can have physical corruption that doesn't get backed up or restored.
May 13, 2015 at 7:10 am
A database is the definition of the structures and other objects that make up a database (tables, views, procedures, users, roles, etc.). The data is stored within the structures of...
May 13, 2015 at 7:09 am
If you offload it to another server, you'll still want to run a PHYSICAL_ONLY check on the first server.
May 13, 2015 at 7:03 am
Create a temporary table or a table variable to put the results into. Run the query, do a JOIN to compare the results. You can use
INSERT INTO #X -- or...
May 13, 2015 at 3:46 am
kanuto.tapon (5/13/2015)
GilaMonster (5/13/2015)
kanuto.tapon (5/13/2015)
May 13, 2015 at 3:23 am
If you're going to maintain the 2000 system for the long term, then I'd treat it like it's a full part of your development and deployment system. Changes to your...
May 13, 2015 at 2:45 am
So you're connecting from the older version of SSMS to the newer SQL Server instance? Yeah, that's going to fail because the software isn't forward compatible. Structures and internals change...
May 13, 2015 at 12:41 am
Your best bet with the current product is probably option #2. If you can move your database to Azure, there is dynamic data masking[/url] that will do exactly what you...
May 12, 2015 at 4:04 am
sys.dm_db_index_usage_stats is the way to go for this information. However, it's worth noting that this will only be good information back to the last time the server was restarted or...
May 12, 2015 at 4:00 am
Some procedure or view or something in the database is referencing the MostFavoredGenerics, but it's gone, so when you script out the objects and try to recreate it, it's failing....
May 11, 2015 at 6:05 am
Viewing 15 posts - 6,106 through 6,120 (of 22,211 total)