Try running these examples.
PRINT 'Int to Hex' SELECT CONVERT(VARBINARY(8), 15987699) PRINT 'Hex to Int' SELECT CONVERT(INT, 0xF3F3F3)
General Tips on Optimizing SQL Server Indexes
Index Fillfactor
Fill factor = 100 fills the pages completely.
Fill factor = 0 leaves space in the index non-leaf pages .
INSERT data from SQL table to EXCEL
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=E:\MSSQL\Reports\JobSchedules.xls;',
'SELECT JobName, ScheduleName, next_run_date FROM [Sheet1$]')
select j.name JobName, s.name ScheduleName,
next_run_date
from msdb..sysjobs j
join msdb..sysjobschedules s
on j.job_id = s.job_id
where j.enabled = 1
and s.enabled = 1
ORDER BY
j.name
GO
— Note:
— Requires E:\MSSQL\Reports\JobSchedules.xls to already exist with the correct columns.
An idle CPU condition has not been defined
SQL Server 2008 Books Online
How to: Set CPU Idle Time and Duration (SQL Server Management Studio)
This topic explains how to define the CPU idle condition for your server. The CPU idle definition influences how Microsoft SQL Server Agent responds to events. For example, suppose that you define the CPU idle condition as when the average CPU usage falls below 10 percent and remains at this level for 10 minutes. Then if you have defined jobs to execute whenever the server CPU reaches an idle condition, the job will start when the CPU usage falls below 10 percent and remains at that level for 10 minutes. If this is a job that significantly impacts the performance of your server, how you define the CPU idle condition is important.
To set CPU idle time and duration
-
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
-
Right-click SQL Server Agent, click Properties, and select the Advanced page.
-
Under Idle CPU condition, do the following:
- Check Define idle CPU condition.
- Specify a percentage for the Average CPU usage falls below (across all CPUs) box. This sets the usage level that the CPU must fall below before it is considered idle.
- Specify a number of seconds for the And remains below this level for box. This sets the duration that the minimum CPU usage must remain at before it is considered idle.
http://msdn.microsoft.com/en-us/library/ms189065.aspx
Change mouse cursor size
System Preferences -> Universal Access -> Mouse
You'll find a setting to increase the size of the pointer there
Import Blogger blogs?
Does this work?
https://sourceforge.net/projects/blogexporter/
Not yet:
2008-08-03 19:27:13,968 DEBUG [BlogExporter.Core.PostParser] Parsing blog 4855217953238557838, post 4841212145285365256: Welcome.
2008-08-03 19:27:13,984 ERROR [BlogExporter.Console.Program] Error while exporting blog
BlogExporter.Core.ExportException: Value not not found: atom:content/text()
at BlogExporter.Core.XPathResolver.GetValue(XPathNavigator node, String xpath, String defaultValue) in H:\Development\Blog\BlogExporter\BlogExporter.Core\XPathResolver.cs:line 55
at BlogExporter.Core.PostParser.ParsePost(XPathNavigator blogPost) in H:\Development\Blog\BlogExporter\BlogExporter.Core\PostParser.cs:line 186
“Your login attempt was not successful. Please try again.”
|
SQL Agent – job history set number of rows
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties
@jobhistory_max_rows=200000,
@jobhistory_max_rows_per_job=10000
GO
SQLCMD Login/User create template
USE master
CREATE LOGIN [$(UserName)] FROM WINDOWS WITH DEFAULT_DATABASE=[$(DatabaseName)] GO USE [$(DatabaseName)] GO CREATE USER [$(UserName)] FOR LOGIN [$(UserName)] GO EXEC sp_addrolemember N'$(RoleName)', N'$(UserName)' GO