-
12 juni 2013 i T-SQL, Level 200, SQL Server allmänt, Håkan Winther, sv, en
Are you using copy and paste in SQL Server Management Studio? Well, I guess everyone does. Did you know that if you copy multiple different T-SQL code...
-
09 juni 2013 i T-SQL, Level 300, Håkan Winther, sv, en
If you have written a stored procedure that you want's to use in every database, you probably noticed that databased scoped objects will only return...
-
31 maj 2013 i T-SQL, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, Level 200, SQL Server maintenance, Håkan Winther, sv
In SQL server there is an undocumented extended stored procedure called xp_servicecontrol. You can use this to start/stop and view the state of the
-
25 april 2013 i SQL Server version, T-SQL, Level 200, SQL Server säkerhet, Göran Rönnbäck, sv
När det gäller rättigheter för användarna i databaserna finns det ingen möjlighet att se detta i SQL Server Management Studio på ett överskådligt sätt...
-
15 april 2013 i T-SQL, Level 400, Håkan Winther, sv, en
First of all, I am not a fan of triggers because of a number of reasons, but i will not go into those in this blog. Anyway, triggers can be useful
-
09 april 2013 i T-SQL, Level 200, SQL Server performance, Göran Rönnbäck, Evenemang, sv
Dag två i ett kyligare Vegas fortsatte för mig med sessionen "Understanding Statement Execution and Optimizing Stored Procedures". Också den hållen av...
-
05 april 2013 i T-SQL, SQL Server 2012, Level 400, Steinar Andersen, SQL Server, sv, en
Today I stumbled over a nice list of documented and undocumented DBCC commands. I verified the content against SQL Server 2012, and unfortunately it...
-
30 mars 2013 i T-SQL, Level 200, SQL Server maintenance, SQL Server performance, Steinar Andersen, sv, en
When you think about monitoring SQL Server instances, you probably often think about monitoring that the service is up, performance, security and such...
-
10 mars 2013 i T-SQL, Level 200, SQL Server performance, Steinar Andersen, SQL Server, T-SQL, sv, en
Today I just wanted to have a little fun, while at the same time brushing off my T-SQL skills. As you know, prime numbershave many uses, for example...
-
07 mars 2013 i T-SQL, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, Level 200, SQL Server allmänt, SQL Server best practices, Göran Rönnbäck, sv
Som vi skrivit om tidigare så finns det möjlighet att slippa den tid det tar för datafilen att växa genom att skippa den sk nollutfyllnaden. Detta kan...