Viewing 15 posts - 691 through 705 (of 1,079 total)
Typing "Sel" or "Ins" etc...and pressing Tab, waiting for auto complete...like cmd.....
:pinch:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 20, 2010 at 4:17 am
Select Distinct FLTNBR,STARTTI
:w00t:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 14, 2010 at 11:28 pm
I completed the cert.....
use BOL.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 7, 2010 at 4:09 am
You will need to provide the error on Step level, and not only package level.
Go into the SQL Agent, under jobs, drop down the specific job, focus on the step...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 31, 2010 at 12:00 am
make use of COLLATE before your "IN"...
COLLATE Latin1_General_CI_AS
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 30, 2010 at 12:08 am
Could you please gimme some question based on this or some topics which might help me at this point???
they could as you to explain what you will do when presented...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 29, 2010 at 11:57 pm
use:
1. SSIS
2. Import/Export Tool
3. Tsql
right click any database, tasks, Import data...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 27, 2010 at 12:30 am
I am getting a bit confused about what you actually want....
Instead of giving your backups custom names, do default backups in sql server which will include a date and timestamp....example:...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 27, 2010 at 12:28 am
in windows explorer you can view the modified date as a column header.
activate it if it's not there by default (which it should be)...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 26, 2010 at 11:40 pm
Familiarize yourself with how SQL Server utilizes CPU and Memory from the Host.
Read up on AWE & PAE, maximum & minimum memory usage; Lock pages in memory; differences in 32bit...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 26, 2010 at 11:28 pm
SELECTt.name as [DB Name],
t.user_access_desc as [Access State],
t.state_desc as [Online/Offline],
((SELECT (CASE t.is_in_standby WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' ELSE 'Other' END))) as [In Standby],
(COALESCE(Convert(datetime, MAX(u.backup_finish_date), 101),'Not Yet Taken')) as...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 26, 2010 at 11:25 pm
Jason, I'm actually aware of a few places who are forced by legacy apps to run 6.5....and by the looks of this:
Correct answers: 38% (54)
Incorrect answers: 62% (89)
Total...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 13, 2010 at 2:19 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 30, 2010 at 12:52 am
There is another side to this.
If you are running a 32bit OS, you'll need to make use of the PAE switch in the Boot.INI as well, to allocate more than...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 27, 2010 at 4:37 am
To start off with, Express is free.
Express 2008 R2 will support up to 10gb DB, anything earlier will only support 4gb.
There are memory limitations etc....
Read up on all the differences:
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 26, 2010 at 11:58 pm
Viewing 15 posts - 691 through 705 (of 1,079 total)