Viewing 15 posts - 91 through 105 (of 1,154 total)
gstarsaini (4/1/2014)
Where can I get detailed notes on "Data compression in SQL server"?It would be helpful if the notes are accompanied with examples.
Check this one ..
http://msdn.microsoft.com/en-us/library/dd894051(SQL.100).aspx
--
SQLBuddy
April 1, 2014 at 9:31 am
Sushant Yadav (4/1/2014)
thanks sqlbuddy for your reply.but it is showing me following out on execution of select statement
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\SQLDTSSS90.DLL
Check if you could find that dll in that...
April 1, 2014 at 9:24 am
lindsayscott23 (4/1/2014)
Thanks for the response. SSIS it is then!cheers
lins
Yep. You are welcome, lins 🙂
--
SQLBuddy.
April 1, 2014 at 9:23 am
maniplusa 9705 (3/31/2014)
I'm new to this forums. I currently work in System/Network support role and find it to be stressful. I want to move on to SQL administration OR...
March 31, 2014 at 4:18 pm
What's your MAXDOP and Cost threshold for Parallelism ?
--
SQLBuddy
March 31, 2014 at 4:14 pm
SQL!$@w$0ME (3/31/2014)
No need to failover before rebooting the second node?
Rebooting does the failover back to the primary node.
--
SQLBuddy
March 31, 2014 at 3:35 pm
Install the SP on the active node and then reboot the Active node followed by the Passive node reboot.
--
SQLBuddy
March 31, 2014 at 3:12 pm
SSMS by itself doesn't cause any locking. It's the queries through SSMS that causes locking\ blocking. Basically its a long running open transaction that can cause issues. Next time when...
March 31, 2014 at 2:59 pm
elhelalaoui (3/31/2014)
I used TheNameOfTheComputer\AdministrateurThanks sqlbuddy123 for your support
I'm in waiting 🙂
You are welcome, elhelaloui. Could you import the package into MSDB, select the SSIS package in the job step and...
March 31, 2014 at 2:24 pm
What's your Isolation level ?
--
SQLBuddy
March 31, 2014 at 11:27 am
elhelalaoui (3/30/2014)
I'm still having this error : Could not get proxy data for proxy_id = 11
When creating the credential were you using DOMAIN\USERNAME or just USERNAME ?
--
SQLBuddy
March 31, 2014 at 10:28 am
adeel.imtiaz (3/30/2014)
I have a SQL Cluster with the followings.
Windows Server 2008 R2
SQL Server 2012
Shared Storage(SAN)
Now i have another requirement of SQL Server 2012 AlwaysOn which a news feature in...
March 31, 2014 at 9:32 am
Did you enable email in SSRS ?
--
SQLBuddy
March 31, 2014 at 9:14 am
Check the SQLAgent Error Log to see any error messages.
Did you restore the msdb from a different server or moved the Maintenance plan from a different server ?
Run this
SELECT *...
March 31, 2014 at 8:58 am
Viewing 15 posts - 91 through 105 (of 1,154 total)