Viewing 15 posts - 301 through 315 (of 1,079 total)
got it wrong, as the correct answer wasn't listed.
your syntax is wrong in, sequence wouldn't be created to start of with...no increment value, no 'AS'..etc.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 16, 2012 at 10:28 pm
if in the same group it should use the new data file.
if you can afford some downtime, i would advise moving the original datafile to the disk with enough...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 16, 2012 at 5:32 am
Autogrow is set on files, not filegroups.
If you add another mdf (data file) enable autogrow on it.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 16, 2012 at 5:23 am
Means the allocated space for the data file, is all you are providing.
NO additional growth can take place on a 100% full data file.
Change autogrow to a value of...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 16, 2012 at 5:15 am
It means 3gb ram is reserved for SQL Server.
When you stop MSSQL - the 3gb is released.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 16, 2012 at 5:14 am
1)how to call stored procedure in ssrs reports ?plz tell me the process
2)how to call userdefined functions in ssrs reports ?plz tell me the process?
Answer to both Questions:
T-SQL calling proc's...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 16, 2012 at 4:04 am
Yeah, dont think DM is the right tool for your game....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 15, 2012 at 10:39 pm
If you have enough disks, best setup would be:
Sys db's on own disk, but have tempdb on its own drive.
user db's on own disk.
split mdf and ldf's as well.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 3:36 am
dbo.sysjobhistory
dbo.sysjobs
These tables in msdb contain all job information, join them on job_id.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 3:05 am
when you refer to perf counter being missing, where did you look for them?
Perfmon?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 2:57 am
Run this query:
SELECT
CONVERT (varchar(30), GETDATE(), 121) as runtime,
dateadd (ms, (a.[Record Time] - sys.ms_ticks), GETDATE()) as [Notification_Time],
a.* , sys.ms_ticks...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 2:54 am
a cube is a multidimensional structure of data, consisting of dimensions and meaures.
See it as a very clever and programmable Pivot Table. <- 😎 Yes, I said that.
Good starting point...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 2:26 am
we are working in clinet location in banking environment so its not possible from my opinion its very long process to get license to all and if u can share...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 1:29 am
You can upload the screenshot in the forum.
You are still running SP3 for SQL 2005. A simple SP4 upgrade should fix the component of SSMS that's not functioning.
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7218
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 1:18 am
Please run SELECT @@VERSION and post results.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 13, 2012 at 1:11 am
Viewing 15 posts - 301 through 315 (of 1,079 total)