Viewing 15 posts - 31 through 45 (of 87 total)
Don't even think about partitioning. If you do not have backup, partitioning is way over your head (not trying to know you, but if you have no backups, indexes,...
January 21, 2014 at 7:24 am
Generally, you want to isolate tempdb from everything else.
December 3, 2013 at 2:40 pm
After testing, I am more confused.
I created a table with 8 columns of various data types, and populated it with random data. I then ran three INSERT...
December 3, 2013 at 8:42 am
How do you define customers. In various roles, I always considered the person or group that I was delivering to as a customer. Sometimes the developers are customers...
August 15, 2013 at 7:59 am
Great stuff here Erin. One minor item I found. Listing 2 has this as part of the script the following line:
; INSERT [BaselineData2012].[dbo].[FileInfo]...
August 13, 2013 at 9:52 am
raadee (8/5/2013)
I would recommend you to have a look at Ola Hallengrens maintenance solution http://ola.hallengren.com.
It is a great solution for backups and mainteance that has made my life much easier....
August 6, 2013 at 9:05 am
You can create a master package that contains all of the other packages, and use multiple precedance constraints to set up the workflow among packages.
August 1, 2013 at 2:14 pm
There is also a possibility of reading inaacurate data even if the table you are accessing does not change. If there is a lot of upadte activity in other...
August 1, 2013 at 5:38 am
Gerard Silveira (7/31/2013)
My question here would be , what about the fragmentation in the datafiles that was caused by the autoshrink ON.Could this be removed somehow ??
Yes, but with a...
July 31, 2013 at 2:52 pm
SQLRNNR (7/31/2013)
tim_harkin (7/31/2013)
Create the proper access in SQL using AD user groups. The the level 1 team can add and remove users from the AD groups as needed.
Very good...
July 31, 2013 at 2:49 pm
When you created the login TestUser, did you specify SQL Server Authentication or Windows Authentication?
July 31, 2013 at 2:26 pm
Create the proper access in SQL using AD user groups. The the level 1 team can add and remove users from the AD groups as needed.
July 31, 2013 at 2:24 pm
BIDS is a 32 bit application, so it uses the 32 bit ODBC driver. When the package is running under SQL Agent, that is a 64 bit process, so...
July 31, 2013 at 2:21 pm
Another option would have been SQL Sentry's Plan Explorer. It is one of my go-to utilities, and even the free version will help your analysis of execution plans a...
July 23, 2013 at 11:43 am
Viewing 15 posts - 31 through 45 (of 87 total)