Viewing 15 posts - 616 through 630 (of 1,079 total)
sqlrocks79 (12/8/2010)
Could anyone please provide me a script (not stored procedure) for finding the avg index fragmentation for all the user databases in an instance ? Actually I...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 9, 2010 at 1:14 am
Ask the sysadmin to provide you account with sufficient permissions to make backups/select.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 7, 2010 at 12:53 am
Pinal Dave has a great tutorial on Table Partitioning...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 7, 2010 at 12:47 am
Initial thoughts would be, you dont have access, but please could you provide more information?
do you have sufficient access, what type 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
December 6, 2010 at 4:35 am
Congratulations, I'm writing 13th Dec....
Hold thumbs.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 3, 2010 at 2:45 am
Hi guys, could we get some comments on the today's QOTD please?
Need some more senior input.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 3, 2010 at 2:45 am
I beg to differ.
Yes, ok, you cant by default right click and select Create (although there is a very nifty add in available to do this).
But what about creating a...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 2, 2010 at 10:26 pm
How can I resolve this situation so that I can connect to the new server, using the old servername.
Speak to you windows server admins, they can create a DNS forwarding...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 16, 2010 at 6:21 am
pradeepniitdln (11/16/2010)
I...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 16, 2010 at 6:18 am
Same here, no issues so far.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 16, 2010 at 6:15 am
KcV (11/16/2010)
can anybody say that
how can i use IN and LIKE both togather in same query and same field ?
select * from pe where yno in like (
'%85452-1',
'%29212-2',
'%61954-1',
'%34483-2')
above...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 16, 2010 at 3:10 am
Junglee_George (11/15/2010)
Can anyone explain SQL Server Query Hints in detail, in a simple fashion.Thanks in advance
There are so many hints, and would take up pages.
All hints are not always applicable...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 16, 2010 at 12:04 am
GilaMonster (11/11/2010)
Henrico Bekker (11/11/2010)
create a small db in 2011, set compat mode to 2008, back up, try to restore in 2008, see the unexpected weird error.....
Not expected to work. Has...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 15, 2010 at 1:21 am
Which media are you using?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 14, 2010 at 11:08 pm
You need to create the shared datasource on the SSRS.
Open your http://hostname/reports page
browse to Datasources, and create it there.
Then upload your report (RDL) file, open it and point it to...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 12, 2010 at 5:37 am
Viewing 15 posts - 616 through 630 (of 1,079 total)