Archive for the ‘SQL Server’ Category

Page 5 of 512345

Calculate Weekdays Between Two Dates

In: SQL Server

24 Sep 2008

SQL Server T-SQL function to calculate the number of weekdays between two dates and helper function to return the maximum of two integers.

List to Table Function

In: SQL Server

22 Sep 2008

Split delimited values into a table using T-SQL UDF.

Checking database file sizes without a GUI

In: SQL Server

19 Aug 2008

A T-SQL query to verify the size and growth settings for a SQL Server database without resorting to the Management Studio GUI.

Round DATETIME to nearest X minute increment

In: SQL Server

15 Aug 2008

Ever needed to round an arbitrary DATETIME to some specified increment (i.e. 5, 10 or 15 minutes)? This function can come in handy for such a task.

Query Active Directory from SQL Server 2005

In: Active Directory|SQL Server

15 Aug 2008

Some time ago, I needed to sync down a list of AD users to use as a lookup (as opposed to querying LDAP on demand). I found this little gem: How to avoid 1000 rows limitation when querying active directory (AD) from SQL 2005 with using custom code. It works great, especially since I submitted [...]


Page 5 of 512345

Categories

Archives

  • shiva ramani: good instruction. How to push data to MySQL from SQL 2005 [...]
  • Winkey: I've created a linked server for mysql successfully, and also can do Insert, Select. But when I try [...]
  • RaghuRam: Thanks a lot buddy it helped me to change the root password when I got the error trying to c [...]
  • Taylor Gerring: If you're on a 64-bit OS, did you run the 32-bit version of ODBC applet? Run: odbcad32 [...]
  • Taylor Gerring: If the issue is the guest sync'ing to the host, can't you just force time sync the host if you can't [...]


This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.