Viewing 15 posts - 2,386 through 2,400 (of 6,041 total)
To be sargable, the query would need to filter on the leading column in the index.
For example, assume we have CLUSTERED INDEX ( StoreID, TransactionID, ProductID ). A query WHERE...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 16, 2016 at 9:16 am
Unless the log growth was the result of a one-off process and the disk space is shared by other databases, I don't see the point in shrinking. Maybe focus on...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 16, 2016 at 9:01 am
Ed Wagner (8/16/2016)
Eric M Russell (8/16/2016)
Ed Wagner (8/16/2016)
Eric M Russell (8/16/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 16, 2016 at 8:57 am
Ed Wagner (8/16/2016)
Eric M Russell (8/16/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 16, 2016 at 8:47 am
It would be useful to have an experienced gray haired DBA who could offer technical assistance and architectural advice across any number of projects, more like an analyst role, wihout...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 16, 2016 at 7:14 am
The engineering DNA of the SQL Server database engine is optimized for online transaction processing, not bulk loading or aggregation.
You may also want to consider BCP-ing the 600 GB...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 16, 2016 at 7:03 am
When SQL Server constructs an execution plan, it takes a lot of things into consideration and it attempts to come up with a good balance. If it is known that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 16, 2016 at 6:49 am
Ed Wagner (8/15/2016)
Eric M Russell (8/15/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 15, 2016 at 1:52 pm
Northwind is obsolete. It was replaced by AdventureWorks, which was replaced by Contoso.
Here is the CodePlex site where Northwind is maintained. It hasn't been updated since release 2008, but you...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 15, 2016 at 10:48 am
.. The explosion in aircraft innovation came when a variety of private companies began to build and fly aircraft. ..
Don't say "explosion" in the context of manned rockets. Instead say...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 15, 2016 at 9:17 am
When it comes to revceiving data feeds from external clients or 3rd party providers, it's best when an auto-certification process breaks the file transfer when the file isn't formatted properly....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 15, 2016 at 9:12 am
There is no secret sauce in SSIS that allows you to insert a table without transaction logging.
The following article provides a good explanation of minimal logging and summary of the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 12, 2016 at 9:45 am
HappyGeek (8/11/2016)
Iwas Bornready (7/25/2016)
Yet Another DBA (7/22/2016)
Time to leave?Hmm, with some companies its the day after I started.
That's sad you didn't know that before you started.
So how exactly do you...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 12, 2016 at 9:31 am
Table Partitioning, TDE, and page compression can all work in conjunction.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 12, 2016 at 9:19 am
Victor Kirkpatrick (8/12/2016)
Thanks Andy, good info. Pardon my ignorance, but what does "C level audience" and "C suite" mean? Client/Customer?
Chief Executive Officer, Chief Information Officer, Chief Happyness Officer, etc.
We're all...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 12, 2016 at 9:11 am
Viewing 15 posts - 2,386 through 2,400 (of 6,041 total)