Viewing 15 posts - 5,956 through 5,970 (of 6,400 total)
Would need to use parameters and ensure that your passing an ISO date format through to the query, something like the below, so the user can pass in a start...
February 13, 2012 at 8:22 am
Thanks Gail, I will take a read.
January 19, 2012 at 7:12 am
running dbcc loginfo gave 32768 results, that I noticed that the log was set to grow in 1MB chunks so thats been changed to 8000MB.
whats the easiest way to reduce...
January 19, 2012 at 6:44 am
The database is in simple recovery so no T-Log backups, full backup nightly after the data warehouse load.
There is approx 200GB which is transfered in due to data changes as...
January 19, 2012 at 6:20 am
Dumps are a breach of the NDA that you sign prior to completing your exams, any use of dumps is cause for all of your certifications being revoked and not...
January 19, 2012 at 6:02 am
Well I passed, was doubting myself a little while I was in there, and was glad that I reviewed a couple of the questions otherwise I bet it wouldnt of...
December 15, 2011 at 3:14 am
that's because sp_send_dbmail exists in the msdb database, so you need to do msdb.dbo.sp_send_dbmail
December 11, 2011 at 1:34 am
December 9, 2011 at 4:56 am
i dont get how the foreign key is working, thats if a foreign key has been recreated
how can a column with values
1
2
3
reference a row with value
1,2,3
just not possible.
December 9, 2011 at 4:54 am
Pradyothana Shastry (12/9/2011)
IN logshipping we can do by stand by mode... that will solve your problem.
To follow on from this, there will be an additional charge for SQL licences should...
December 9, 2011 at 4:11 am
Prerequisites, Restrictions, and Recommendations for Database Mirroring
December 9, 2011 at 2:41 am
In that case I would set the memory available to SQL to 22GB for server1 and 10GB for server2, I wouldnt usually do this via sp_configure, yet the GUI
right click...
December 9, 2011 at 2:38 am
what are the servers going to be doing
as it will all depend on what you need to configure.
are they just the SQL engine, or do they have SSAS/SSIS/SSRS as well...
December 9, 2011 at 2:27 am
you could but a group by or a distinct in the query to rollup the data so that the duplicates are removed.
group by
select
...
December 9, 2011 at 2:19 am
what do you need to configure?
first thing would be show advanced options to get the full list of configurables.
sp_configure 'show advanced options',1
go
reconfigure
go
December 9, 2011 at 2:16 am
Viewing 15 posts - 5,956 through 5,970 (of 6,400 total)